Forum Discussion

juliejo's avatar
juliejo
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's avatar
    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!

juliejo's avatar
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's avatar
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:

 

Resources