Belinda,

Try this

if(B6="FT", if(D64,15,if(D6=2,10,if(D6=1,5,0,""))),"")

Wkr,

JP



"Belinda" wrote in message
...
=IF(AND(B6="FT",(IF(D64,15,IF(D6=2,10,IF(D6=2,1 0,IF(D6=1,5,0)

Hi. I am trying to create a formula to return the values above if the
"B6="FT" is true. If true return the values for the nested if statement,
else
return zero. I either get an error or "True" or "False". I want to return
either 15, 10,5, or zero. Can you help me fix this formula to give me the
results I need?

Thank you!