Thread: IF OR Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j5b9721 j5b9721 is offline
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!!!!