IF OR Help
Hi I need this...
cd6 gives price % change, the differance between 2 days, and has a formula
in the cell =IF(CD7="","",(CD7-CC7)/CC7) to find the change.
In the "conditional formating" section... in "conditon 2" I need this to
take place.
The fill if triggered is red text and yellow background.
I only need examples of how to write these formulas using IF & OR...
(cd6<=0,cd6=-0.0499) ...this I need to know the way to write it
If cell cd6 formated if no entry is given to not color fill.
Logical 1... if cd6<=-5%
Logical 2... if cd6 is between 0 & -0.0499
Logical 3... if cd6<=-5% to "Sum(ca6:cd6) past 4 days % changes" if it's
total is =5% of the cell cd6 in to cell.
IF(cd6="","",OR((cd6<=-5%),(cd6<=0,cd6=-0.0499),(cd6<=-5%,Sum(ca6:cd6)=5%)),"")
"Eduardo" wrote:
Hi,
Please provide an example of what you want to achieve, thanks
"j5b9721" wrote:
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!!!!
|