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

if(and(k141,h146.49);check pay rate;if(and(k14<1,h147.21);check
rate;; ))

i think that should work for you.


--
ehntd
------------------------------------------------------------------------
ehntd's Profile: http://www.excelforum.com/member.php...o&userid=15865
View this thread: http://www.excelforum.com/showthread...hreadid=277337

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

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

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

You're welcome !
(from us)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"John" wrote in message
...
Thanks all