IF OR problem
Phil Smith & Pete_UK,
Your answers worked great however now I need to make the situation a whole
bunch more complicated.
In =IF(E3="U6",120,0) the 120 refers to a value that is date sensitive and
in cells M1, N1 or O1.
For example:
120 would be the answer from Aug 1, 09 to Aug 25, 09 in cell M1
130 would be the answer from August 26, 09 to Sept 3, 09 in cell N1
150 would be the answer for any date after Sept 3, 09 in cell O1
The reference date would be in cell P1
K L M N O
Aug 1 - 25 Aug 26 - Sept 3 Sept 4 +
1 U6 Comm 120 130 150
2 U8 Comm 175 185 205
3 U10-U16 Comm 280 290 330
4 U10-U16 Dev 340 350 395
5 U10-U16 Tier 350 360 405
6 U18 Comm 300 310 350
7
8 8/10/09
If the reference date in cell K8 was August 10, 09 then the value in
question would be found in cell M1 however if the reference date was August
28, 09 then the value in question would be found in cell N1
The same thing would also have to happen in the other sections of the
formula thus making the formula a whole bunch more complicated.
Any thoughts on how I would incorporate this back into the formula.
Thanks
Kerry
"Pete_UK" wrote:
Try this:
=IF(E3="U6",120,0)+IF(E3="U8",150,0)+IF(E3="U18",3 75,0) + IF(AND
(G3="com",OR(E3="U10",E3="U12",E3="U14",E3="U16")) ,350,0) + IF(AND
(G3="dev",OR(E3="U10",E3="U12",E3="U14",E3="U16")) ,380,0) + IF(AND
(G3="Tier",OR(E3="U10",E3="U12",E3="U14",E3="U16") ),410,0)
Hope this helps.
Pete
On Dec 3, 9:16 pm, ksean wrote:
Not sure where to start with this formula but I need a single formula that
results in multiple possible answers.
Here is what I have
If E3 = "U6" then 120 or
= "U8" then 150 or
= "U10" or "U12" or "U14" or "U16" and G3 = com then 350 or
= "U10" or "U12" or "U14" or "U16" and G3 = dev then 380 or
= "U10" or "U12" or "U14" or "U16" and G3 = Tier then 410 or
= "U18" then 375
Cell E3 could have 7 possible entries and cell G3 could have 3 possible
entries
The answer needs to be 120 or 150 or 350 or 380 or 410 or 375
This all needs to be in one formula.
.
|