Thread: if Error
View Single Post
  #1   Report Post  
John
 
Posts: n/a
Default if Error

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