View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BELINDA BELINDA is offline
external usenet poster
 
Posts: 6
Default Nested If/And/Or statements

=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!