View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default if function shows 0 instead of blank

You don't need a nested if statement for this, try the following:

=IF(F38="YES",C25,"")
--
Kevin Backmann


"Wanna Learn" wrote:

Hello this is my formula =IF(F38=" "," ",IF(F38="YES",C25,FALSE)) I do
not get the result I want. If F 38 is blank it shows a 0 .I do not want the
zero I want it to be blank thanks