I'm working off a macro that was passed down to me. I have inserted a simple formual, =J4/H4, but would like to run an IFERROR to return a blank cell. It won't let me do this. Any alternatives?
I'm working off a macro that was passed down to me. I have inserted a simple formual, =J4/H4, but would like to run an IFERROR to return a blank cell. It won't let me do this. Any alternatives?
How about:
=IF(H4="", "", J4/H4)
or
=IF(H4=0, "", J4/H4)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
The first formula returned FALSE and the second one made me debug. I'm looking for the cell to be blank until the the other cells are filled in with information.
How about this one
Please Login or Register to view this content.
Which other cells, exactly, in a formula you can do all that if you specify?
Examples:
=IF(COUNTA(A4:D4)<4, "", <MyFormula>)
=IF(ISERROR(<MyFormula>), "", <MyFormula>)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks