Too many arguments - IF formula

[Zipping2010]

Hi,

I'm receiving the error - You've entered too many arguments for this function.

I'm trying to create a formula where if I2 is greater than 1.1 and if J2 is greater than 0.99 then display O2 - if false leave blank.

=IF(I2>1.1,O2,"",IF(J2>0.99,O2,""))

Cheers

[daddylonglegs]

Do you mean both of those conditions need to be fulfilled?

Try using AND

=IF(AND(I2>1.1,J2>0.99),O2,"")

if it's either condition then replace AND with OR

[Zipping2010]

Yeh it was both of these conditions...it works....thanks for your help!