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!

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jun 18, 2021

juliejo 

There are only two cases which create #VALUE!.

1. F55 contains text and Worksheet!B7 is not empty.

2. D55 contains text.

Neither would make sense.

 

Resources