Combining two functions
Your welcome,
"preyesone" wrote:
Awesome! Thank you so very much!
"Eduardo" wrote:
I hit enter before finishing, is that is the case
=IF(J4="Yes",1,IF(SUM(E4+F4+(G4/H4)*0.8)<0.6,0.05,IF(SUM(E4+F4+(G4/H4)*0.8)<0.8,0.1,IF(SUM(E4+F4+(G4/H4)*0.8)0.8,0.15))))
"Eduardo" wrote:
Hi,
Sorry I don't understand something, if J4 has yes you want 1 otherwise you
want 0.5 or 0.8 etd, is that correct??
"preyesone" wrote:
Nope! Now I have to have J4 as Yes to get any answers. IF J4 is populated
with Yes, then the total should be 1
For .5 = 0.5, .7 = .1, .8=.15, .99=1
"Eduardo" wrote:
Hi,
try
=IF(AND(SUM(E4+F4+(G4/H4)*0.8)<0.6,J4="Yes"),0.05,IF(AND(SUM(E4+F4+(G4/H4)*0.8)<0.8,J4="Yes"),0.1,IF(AND(SUM(E4+F4+(G4/H4)*0.8)0.8,J4="Yes"),0.15)))
"preyesone" wrote:
Unfortunately it's only picking up the first portion of the formula and
giving a .05 for the answer no matter what the SUM is.
"Shane Devenshire" wrote:
Hi,
The AND portion says if J4="Yes" and 1 then TRUE, otherwise FALSE. why not
just say IF(J4="yes",1,"whatever")
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"preyesone" wrote:
I am trying to combine the IF/And functions:
=IF(SUM(E4+F4+(G4/H4)*0.8)0.5,0.05,IF(SUM(E4+F4+(G4/H4)*0.8)0.6,0.1,IF(SUM(E4+F4+(G4/H4)*0.8)0.8,0.15,AND(J4="Yes",1))))
However it is not recognizing the And portion. No matter what the formula
total is, it should give a 1 if cell J is yes. Can someone help me?
|