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


  #2   Report Post  
ehntd
 
Posts: n/a
Default


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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Max
 
Posts: n/a
Default

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   Report Post  
John
 
Posts: n/a
Default

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   Report Post  
Max
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Findlink Error D Moniz via OfficeKB.com Links and Linking in Excel 0 January 20th 05 05:53 PM
Error when entering and exiting excel Randy Excel Discussion (Misc queries) 1 January 11th 05 04:17 PM
Downloading Templates for Excel error with a windows error. Lanie Moore Excel Discussion (Misc queries) 0 December 21st 04 12:39 AM
How to set Error Bars to _two_ SDs? [email protected] Charts and Charting in Excel 1 December 7th 04 03:00 AM
#REF error Christen Excel Worksheet Functions 5 November 3rd 04 08:29 PM


All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"