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!!!!
|