View Single Post
  #4   Report Post  
Michael
 
Posts: n/a
Default

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.