| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How not to round a formula | Excel Discussion (Misc queries) | |||
| Round up Formula Help | Excel Discussion (Misc queries) | |||
| How do i round up the sum of a formula | Excel Discussion (Misc queries) | |||
| How do I NOT round off in a formula | Excel Worksheet Functions | |||
| formula to round up? | Excel Worksheet Functions | |||
Linear Mode
