View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default Don't want #value in cell

Hello this is my formula =IF(Q3-P3=0,"",Q3-P3) There are not always
numbers in columns Q and P . so when P and Q are blank with this formula I
get an answer of #value! . How can I correct the formula so that if P and Q
are blank my answer should also be a blank cell thanks so much