Multiple IF functions
 

I need one function to always be true and then two IF functions, but can't
seem to get them all to work together.
=C1*.005,IF(B1=A1,C1*.01,"NO"),IF(B1=D1,C1*.012, "NO")
Thank you.

In addition, I've tried this,

=IF(C11,C1*.005,IF(B1=A1,C1*.01,IF(B1=D1,C1*.01 2,"NO")))

but keep getting the result from the first IF function no matter what I
enter for B1. Thank you.

"sonicj" wrote:

I need one function to always be true and then two IF functions, but can't
seem to get them all to work together.
=C1*.005,IF(B1=A1,C1*.01,"NO"),IF(B1=D1,C1*.012, "NO")
Thank you.

Hi!

but keep getting the result from the first IF function no
matter what I enter for B1.

=IF(C11

If that condition is true the formula stops at this point:

=IF(C11,C1*.005)

It doesn't matter what you enter in B1 because the formula
never gets that far if C11.

There's nothing wrong with the formula' syntax. May be
that the logic is just not correct for the result you're
after.

Biff

-----Original Message-----
In addition, I've tried this,

=IF(C11,C1*.005,IF(B1=A1,C1*.01,IF
(B1=D1,C1*.012,"NO")))

but keep getting the result from the first IF function no
matter what I
enter for B1. Thank you.

"sonicj" wrote:

I need one function to always be true and then two IF
functions, but can't
seem to get them all to work together.
=C1*.005,IF(B1=A1,C1*.01,"NO"),IF(B1=D1,C1*.012, "NO")
Thank you.
.

Hi
Try this:
=IF(B1=A1,C1*0.11,IF(B1=D1,C1*0.012,IF(C11,C1*0 .005,"NO")))

HTH
Michael

"sonicj" wrote:

I need one function to always be true and then two IF functions, but can't
seem to get them all to work together.
=C1*.005,IF(B1=A1,C1*.01,"NO"),IF(B1=D1,C1*.012, "NO")
Thank you.