if Error

[John]

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((K14>1,(IF(H14>6.49,"** Check Pay Rate **"),(IF(H14>7.21,"** Check Pay
Rate **))

 

[ehntd]

if(and(k14>1,h14>6.49);check pay rate;if(and(k14<1,h14>7.21);chec
rate;; ))

i think that should work for you

 

[Frank Kabel]

Hi
try:
=IF(AND(K14>1,H14>6.49),"** Check Pay Rate **",IF(AND(K14<1,H14>7.21),"**
Check Pay Rate **",""))

 

[Max]

One way ..

Try:

=IF(OR(AND(K14>1,H14>6.49),AND(K14<1,H14>7.21)),"** Check Pay Rate **","")

 

[John]

Thanks all

One way ..

Try:

=IF(OR(AND(K14>1,H14>6.49),AND(K14<1,H14>7.21)),"** Check Pay Rate **","")

 

[Max]

You're welcome !
(from us)