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 A2 by £8.08.
Not sure if it should be an IF formula is there is a calculation in it.
Can anyone advise on how to do this?
Thanks!
Katy
Hi Katy,
This is the formula:
=IF(A1="R/O",0,IF(A1="B&B",A2*8.08,"N/A"))
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)
