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.
|