Forum Discussion
Help with Formula - can you have a calculation in an IF formula?
Hi there,
I'm an excel novice and can only do simple formulas! I'm having difficulty doing a formula which is essentially:
If the cell A1 is R/O put 0.00 in, if it is B&B multiply cell...
Of course, you can have a calculation inside IF function, not just a single calculation, as many calculations as you like!
Try this:
=IF(A1="R/O",0,A2*8.08)