Dear team,
Can someone please help me for a nested if formula. I need to write a formula enable to do the following conditions in one if statement -
Appreciate all the help.
Thank you.
Can someone please help me for a nested if formula. I need to write a formula enable to do the following conditions in one if statement -
No | Buy Currency | Sell Currency | Purchase Value (Column M) | Sell Value (Column O) | Notional value (Column V) | Formula | Notes |
1 | EUR | USD | 0+ V-M * -1 | If buy currency is EUR, and sale currency is USD, then formula is zero + notional – sale *-1 | |||
2 | EUR | GBP | 0+ V-M *-1 *1.28 | If buy currency is EUR, and sale currency is GBP, then formula is zero + notional – sale *-1 * 1.28 | |||
3 | USD | EUR | 0+ V-M *-1 | If buy currency is USD, and sale currency is EUR, then formula is zero + notional – sale *-1 | |||
4 | USD | GBP | 0+ V-M *-1 | If buy currency is USD, and sale currency is GBP, then formula is zero + notional – sale *-1 | |||
5 | GBP | EUR | 0+ V-M *-1 *1.28 | If buy currency is GBP, and sale currency is EUR, then formula is zero + notional – sale *-1 * 1.28 | |||
6 | GBP | USD | 0+ V_M *-1 | If buy currency is GBP, and sale currency is USD, then formula is zero + notional – sale *-1 | |||
7 | Any other | EUR | V-O *-1 +0 | If buy currency is any other than EUR and sale currency is EUR, then formula is notional – sale *-1 +zero | |||
8 | Any other | USD | V-O *-1 +0 | If buy currency is any other than USD and sale currency is EUR, then formula is notional – sale *-1 +zero | |||
9 | Any other | GBP | V-O *-1 +0 | If buy currency is any other than GBP and sale currency is EUR, then formula is notional – sale *-1 +zero | |||
10 | EUR | Any other | 0+ V-M *-1 *1.17 | If buy currency is EUR and sale currency is any other than EUR, then formula is zero + notional – purchase *-1 * 1.17 | |||
11 | USD | Any other | 0+ V-M *-1 | If buy currency is USD and sale currency is any other than USD, then formula is zero + notional – purchase *-1 | |||
12 | GBP | Any other | 0+ V-M *-1 *1.28 | If buy currency is GBP and sale currency is any other than GBP, then formula is zero + notional – purchase *-1 * 1.28 | |||
Appreciate all the help.
Thank you.