Hi
try:
=IF(AND(K141,H146.49),"** Check Pay Rate **",IF(AND(K14<1,H147.21),"**
Check Pay Rate **",""))


"John" wrote:

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 **))