Help with Formula - can you have a calculation in an IF formula?

[Katy Baron]

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

[#2]

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)

[#3]

Hi Katy,

This is the formula:

=IF(A1="R/O",0,IF(A1="B&B",A2*8.08,"N/A"))