Thanks all
"Max" wrote in message
...
One way ..
Try:
=IF(OR(AND(K141,H146.49),AND(K14<1,H147.21)),"* * Check Pay Rate **","")
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"John" wrote in message
...
I am trying to write an if function and there is a syntax error in the
formula. The outline of the formula is
If K14 is 1, and if H14 is 6.49 then "** Check Pay Rate **"
if K14 is < 1, and if H14 is 7.21 then "** Check Pay Rate **"
Otherwise <blank
My attempt is
=IF((K141,(IF(H146.49,"** Check Pay Rate **"),(IF(H147.21,"** Check
Pay
Rate **))
|