View Single Post
  #2   Report Post  
sonicj
 
Posts: n/a
Default

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.