I have created a table which will be filled in over time. The formulas which are in place which use + or - I can set with =IF(?=0,"",?) to give a blank cell in those awaiting input. However, when the formula depends upon division I get an error message all the way down my table. Can anyone help give me blank cells please.
just set the if(?=0 to the cells that contain the divisor or you could have if(or(a1="",g1=""),"",
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Test the devisor for 0..
If you have
=A1/B1
B1 being blank or 0 is the cause of the error
So try
=IF(B1="","",A1/B1)
Thanks very much to both of you - it's usually straight forward isn't it? I had been using 0 rather than "" . Happy now thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks