X
xpnovice
Hi,
In creating items such as invoices with pre-set formula and functions blank
cells often cause a #Value error.
To overcome this I use a basic IF statement such as =IF(B9="","",E20*E28)
or I may use the ISBLANK function such as =IF(ISBLANK(B9),"",E20*E28)). As
far as I can see, both are effective and work okay, although the 2nd option
(with ISBLANK) is a more compact formula. My question is simply, is there a
"correct" one between these 2 options, or will both work in all
circumstances. (As I said they work for me, at the moment with the formulas
I currently work on, but would one be better than the other for say more
complicated formulae that may arise in the future.)
Thanks
In creating items such as invoices with pre-set formula and functions blank
cells often cause a #Value error.
To overcome this I use a basic IF statement such as =IF(B9="","",E20*E28)
or I may use the ISBLANK function such as =IF(ISBLANK(B9),"",E20*E28)). As
far as I can see, both are effective and work okay, although the 2nd option
(with ISBLANK) is a more compact formula. My question is simply, is there a
"correct" one between these 2 options, or will both work in all
circumstances. (As I said they work for me, at the moment with the formulas
I currently work on, but would one be better than the other for say more
complicated formulae that may arise in the future.)
Thanks