Adding An Absolute Condition to an IF command

[SamuelT]

Hi all,

I've currently got a formula that looks like this:

=IF(A1="Yes","2",IF(A1="Perhaps","1",IF(A1="No","0","n/a")))

All fair and dandy. Now, I've had to add a condition to this formula
which says, "If Cell C1 says "Ready" then execute the formula, if it
doesn't, do nothing".

Is there a means of creating an 'absolute condition' (in this case that
C1="Ready") that I can tell Excel to check before it actually executes
the formula displayed above?

TIA,

SamuelT

 

[Bob Phillips]

=IF($C$1="Ready","",IF(A1="Yes","2",IF(A1="Perhaps","1",IF(A1="No","0","n/a"
))))


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[SamuelT]

Hi,

Thanks for the suggestion, but what that formula does is execute the
formula, only when C1 DOESN'T equal "Ready" - need it the other way
round!

SamuelT

 

[Bob Phillips]

=IF($C$1<>"Ready","",IF(A1="Yes","2",IF(A1="Perhaps","1",IF(A1="No","0","n/a
"
))))


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[SamuelT]

OK - so I've sorted it. Thanks for your assistance Bob.

Simply putting:

=IF(C1="Ready",IF(A1="Yes","2",IF(A1="Perhaps","1",IF(A1="No","
","n/a"))))

...seems to work. It never actually returns an "n/a" value, but instea
one of FALSE where C1 isn't "Ready". However, when C1 does equal "Ready
I am getting the scoring that I wanted, which is the result I wa
ultimately after.

Who knew!!!

Samuel