I have the situation where any of 3 letters may be placed in a given cell, and depending upon which letter appears a different result is to calculated in another cell. I'm using the following formula and keep getting an error message:
=IF(G6="p",0,IF(G6="L"),-E6*25,E6*25)
I'd be grateful if someone would tell me where I'm going awry and how to correct the formula.
Thanks in advance.
=IF(G6="p",0,IF(G6="L"),-E6*25,E6*25)
I'd be grateful if someone would tell me where I'm going awry and how to correct the formula.
Thanks in advance.