View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default how do I insert a cell based on its match with an adjacent cel

=IF(formula="","",formula)

--
Regards,

Peo Sjoblom

Portland, Oregon




"Gabbon" wrote in message
...
Perfect!
Thank you very much--I appreciate it
(I still need to find a way to have the cell appear blank when the
sub-entry
data is blank. Entering a space does the trick, but I'm sure there is
another formula to use to return a blank cell rather than a cell with 0 in
it)
Gabon