Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!! |