Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 63
Default IF OR Help

I need to add these into "conditional formating" section... in "conditon 2"
But dont know how to enter the formula. I keep getting error messages that
the formula is wrong.

I dont want to the "fill" in the cell if nothing is entered in "cd6"
but it needs all these in the string as logical situations also.

IF(cd6="","",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%))

I know this is writen the long way.... (cd6<=0,cd6=-0.0499)
how do I shorten it? (cd6<=0,-0.0499)???

After adding the formula it turns the string into this...
="IF(cd6="""","""",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%))" but it dont work corectly.

Thanks for looking & your Help!!!!

 
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



All times are GMT +1. The time now is 12:09 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"