View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default If formula = Nothing nothing

Hello Here is my formula =IF(B28="Master Agreement","Master Agreement is
valid for 3 years .","Blanket Agreement is for 1 year period. "). how do I
correct the formula so that if B28 is blank nothing shows. thanks