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
|