If in Excrl not in VBA

[Guest]

Hi

If i use the function if in a sheet
and i want
F12 >3900 and F12 < 3999

How do i write this

Alvin

 

[Guest]

Perhaps,

=IF(AND(F12>3900,F12<3999),"Do this if true","Do this if not true")

Mike

 

[Guest]

Thanks



"Mike H" skrev:

Perhaps,

=IF(AND(F12>3900,F12<3999),"Do this if true","Do this if not true")

Mike