View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default formula does not calculate blank answer

Hello

What's wrong with this formula
=IF((AO409+AP409)<0.5,(AO409+AP409),0.5),'' ",
IF(AO409+AP409)<0.5,(AO409+AP409),0.5))

I tested the formula with the first part
IF((AO409+AP409)<0.5,(AO409+AP409),0.5) and that works but when I added the
second part it does not work . THe columns have numbers but sometimes there
is text in the columns, so when there is text I want the cell to be blank
thanks