Forum Discussion

Copper Contributor

Jun 18, 2021

Solved

ISBLANK formula with ROUNDUP and IFERROR

So, I have this lovely little formula that works great, but I need it to do a little bit more than it does now. The 3% cell features this formula: =IF(ISBLANK(Worksheet!B7),D55*0.03,(D55+F5...

excel

Formulas and Functions

juliejo
Jun 21, 2021
Never mind! I figured it out:

=IFERROR(IF(ISBLANK(Worksheet!B7),ROUNDUP(D55*0.03,0),ROUNDUP((D55+F55)*0.03,0)),"")

Thanks!

Yea_So

Bronze Contributor

Jun 20, 2021

Hi juliejo ,

format your cells in currency so when you do a calculation of:

The 3% cell features this formula: =IF(ISBLANK(Worksheet!B7),D55*0.03,(D55+F55)*0.03)

Worksheet!B7=the rush percentage, which is initially filled out on another sheet and will usually be blank.

D55=the base price shown above

F55=the rush price shown above

it won't error out since if D55=0, and F55=0 will be D55+F55=0*0.03= $0.00

so there will be no iferror or isblank.

cheers

juliejo

Copper Contributor

Jun 21, 2021

I should have been more clear. The #VALUE! error is showing up BEFORE any values have been filled in. It's distracting and may confuse users, so I'm just trying to hide it.

But my far bigger issue is getting the resulting value to round up. I can live with the value error, but the rounding up is a deal breaker. I need to figure that one out.

Thanks!

Detlef_Lewin
Silver Contributor
Jun 21, 2021
juliejo

I should have been more clear. The #VALUE! error is showing up BEFORE any values have been filled in. It's distracting and may confuse users, so I'm just trying to hide it.
Not in my worksheet:
juliejo
Copper Contributor
Jun 21, 2021
Never mind! I figured it out:

=IFERROR(IF(ISBLANK(Worksheet!B7),ROUNDUP(D55*0.03,0),ROUNDUP((D55+F55)*0.03,0)),"")

Thanks!