Good Afternoon Ennio,
Perhaps an IF formula statement would work.
Take Care.
Scooter
College Park, MD USA
Ennio-Sr wrote on 8/24/2012 12:13 PM:
Hi all,
When I opened one of my spreadsheets I found many cells were filled
with the '#VALUE!' warning.
They are very old indeed (year 2008) but they used to work fine when I
converted them from M$ stuff with some modifications.
As there are many trasnsactions involving subtraction between dates, I suspect
that missing
value dates may be responsible for the error: i.e. if the formula says
'= (dateA - dateB)*n' and DateB is null, then the formula does not work.
On the other hand, if a date is null that means that there was no
transaction, so I cannot fill all void dates with a foo-value...
Can you help me?
Thanks for your attention,
ennio
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
