Forum Discussion
Nested if statement multiple sheets
Hi, I'm trying to create a nested IF statement as follows, the following formula works correctly and as expected: =IF($D$2="points",$C$5*$G$7,IF($D$2="Discount or GWP",$C$6,IF($D$2="Cash Rew...
The formula is OK. Make sure that you have spelled the sheet name correctly. Could it perhaps be "Business Case Refs " (with a space at the end) instead of "Business Case Refs"?
- I tried this, and changed the tab name to a single word, no luck.
Also tried a simpler statement to see if it works:
=IF($C$2="Points",$C$6*References!B2)
No luck!
