Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 **)) |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 **)) |
#4
|
|||
|
|||
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 **)) |
#5
|
|||
|
|||
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 **)) |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Findlink Error | Links and Linking in Excel | |||
Error when entering and exiting excel | Excel Discussion (Misc queries) | |||
Downloading Templates for Excel error with a windows error. | Excel Discussion (Misc queries) | |||
How to set Error Bars to _two_ SDs? | Charts and Charting in Excel | |||
#REF error | Excel Worksheet Functions |