I have a series of formulas over a number of rows that are currently showing #VALUE! as the formula cant complete the calculation until numbers are entered into the correct cells.
How can a blank these out so that they only show a value if the row is filled in.
Thanks in advance!
maybe try this format
=if(a1="","",[your formula here])
Happy with my advice? Click on the * reputation button below
Or IFERROR([your formula},"")
There is also the ISBLANK Function. =IF(ISBLANK(Your Cell),"",Your Formula)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks