ExcelBanter - Round up this formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Round up this formula (https://www.excelbanter.com/excel-discussion-misc-queries/229380-round-up-formula.html)

Jim

Round up this formula

Hello,

Will someone help me with this? I need to change this formula so it will
round up to the next whole number:

=IF(ISERROR(G48*C49),"",IF(G48*C49=0,"",G48*C49))

Thanks for the help.

Mike H

Round up this formula

Maybe this

=IF(ISERROR(G48*C49),"",IF(G48*C49=0,"",ROUNDUP(G4 8*C49,0)))

Mike

"Jim" wrote:

Hello,

Will someone help me with this? I need to change this formula so it will
round up to the next whole number:

=IF(ISERROR(G48*C49),"",IF(G48*C49=0,"",G48*C49))

Thanks for the help.

Jim

Round up this formula

Mike,

this did not work. I tried chanding it up a little with no success. Any
other thoughts?

Thanks
Jim

"Mike H" wrote:

Maybe this

=IF(ISERROR(G48*C49),"",IF(G48*C49=0,"",ROUNDUP(G4 8*C49,0)))

Mike

"Jim" wrote:

Hello,

Will someone help me with this? I need to change this formula so it will
round up to the next whole number:

=IF(ISERROR(G48*C49),"",IF(G48*C49=0,"",G48*C49))

Thanks for the help.

Tammyp

Round up this formula

This formula should work

=round(IF(ISERROR(G48*C49),"",IF(G48*C49=0,"",ROUN DUP(G48*C49,0))),0)
--
Tammy

"Jim" wrote:

Mike,

this did not work. I tried chanding it up a little with no success. Any
other thoughts?

Thanks
Jim

"Mike H" wrote:

Maybe this

=IF(ISERROR(G48*C49),"",IF(G48*C49=0,"",ROUNDUP(G4 8*C49,0)))

Mike

"Jim" wrote:

Hello,

Will someone help me with this? I need to change this formula so it will
round up to the next whole number:

=IF(ISERROR(G48*C49),"",IF(G48*C49=0,"",G48*C49))

Thanks for the help.

All times are GMT +1. The time now is 04:05 PM.