View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
minyeh minyeh is offline
external usenet poster
 
Posts: 30
Default BLANK cell as a result of IF condition

On Nov 26, 6:14*pm, Vlado Sveda
wrote:
David, Jacob,

thanks for your answers. I had a sinking feeling about impossibility ...,
nevertheless I tried ...

Once more thank a lot !

Vlado


a way to achieve what u want is to
record a macro for ur calculation
=IF(MyCondition; ValueIfTrue; 1/0)
*note: 1/0 returns to an error #DIV/0!
then
F5 goto Special Formula Errors
then
DELETE
end macro recording

might not be the best solution, but hope it helps