Thread: if statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default if statement

Do you mean

=IF(F12=0,0,IF(F4<11908,25,IF(F4<=230954,F4*0.21%, 485)))

--
Jacob


"Tina" wrote:

I have the below IF statement in F14, which is working, however I need the
result to be 0.00 if F12 is 0.00.

=IF(F4<11908,25,IF(F4<=230954,F4*0.21%,485))

Can someone please help?

Thank you.