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...
Which kind of error do you have?
Formulas have bit different logic.
First
=IF($D$2="points",...,IF($D$2=...,$C$6,IF($D$2=...,$C$7*...)))
Second
=IF($C$2="Points",...,IF($C$2=...,$C$7,IF($C$2=...,$C$9*'...)))
Hey,
The error is just #Value!
The error is just #Value!
With wrong reference you'll have #REF! error. With #VALUE! it's something else, e.g. you try to multiply text on number.