IF OR Help

  • Thread starter Thread starter j5b9721
  • Start date Start date
J

j5b9721

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!!!!
 
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%)),"")
 
Hi David...
I do understand a little about the AND formula, but my problem goes deeper
then that from what I tried to do today. I hope you will be able to help me
solve this problem as it's becoming very complicated and taxing to me also.
If you have time I will appreciate your help. It seams that I may need in CF
a multi-situation in 2 Conditions.
What I need to know is if you want me start from the beginning, or go
straight to the problem, you just may not follow whats happening with my
explination.

BZ CA CB CC CD
221 19 -65 74 --- line 4


-0.53% 1.78% -1.75% 5.89% --- line 6 Formula is
=IF(CC7="","",(CC7-CB7)/CB7)
<--- for "CC6"+

It needs CF "Condition 1" has a few given situations that are need.

Condition 1 needs... (red text only)
CC6 to be between 0% and -4.9% "TRUE"
If CC6<-5%, BY6 ... CB6 and if any is >=CC6 "TRUE"
If CC6<-5%, Sum(BY6:CB6) must be >4.75% "TRUE"
If CC6<-5%, BY4 ... CB4 all must be <60 "TRUE"

Can you also help me with "Condition 2"???
Thanks for your time...
Joe
 
Back
Top