Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding up to the nearest dollar
I am using the following formula
=IF((F2*0.85)(E2*1.1),(ROUND(F2*0.85,0)),(ROUND(E 2*1.09,0))) the result rounds the number to the nearest $5 but I want it rounded up to the nearest $1. Can someone help? I am sure this is easy but...... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding up to the nearest dollar
Nevermind it was just my very tired mind.....
"MLShef" wrote: I am using the following formula =IF((F2*0.85)(E2*1.1),(ROUND(F2*0.85,0)),(ROUND(E 2*1.09,0))) the result rounds the number to the nearest $5 but I want it rounded up to the nearest $1. Can someone help? I am sure this is easy but...... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding up to the nearest dollar
I was about to ask when I saw your second post, you don't need so many
brackets though, =IF(F2*0.85E2*1.1,ROUND(F2*0.85,0),ROUND(E2*1.09, 0)) Regards, Alan. We've all done it, woods and tree's! "MLShef" wrote in message ... Nevermind it was just my very tired mind..... "MLShef" wrote: I am using the following formula =IF((F2*0.85)(E2*1.1),(ROUND(F2*0.85,0)),(ROUND(E 2*1.09,0))) the result rounds the number to the nearest $5 but I want it rounded up to the nearest $1. Can someone help? I am sure this is easy but...... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding up to the nearest dollar
I'd put the ROUND around........
=ROUND(IF(F2*0.85E2*1.1,F2*0.85,E2*1.09),0) "Alan" wrote: I was about to ask when I saw your second post, you don't need so many brackets though, =IF(F2*0.85E2*1.1,ROUND(F2*0.85,0),ROUND(E2*1.09, 0)) Regards, Alan. We've all done it, woods and tree's! "MLShef" wrote in message ... Nevermind it was just my very tired mind..... "MLShef" wrote: I am using the following formula =IF((F2*0.85)(E2*1.1),(ROUND(F2*0.85,0)),(ROUND(E 2*1.09,0))) the result rounds the number to the nearest $5 but I want it rounded up to the nearest $1. Can someone help? I am sure this is easy but...... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
What is the formula for rounding a dollar amount to the nearest ni | New Users to Excel | |||
rounding to nearest hundred dollar in Excel | New Users to Excel | |||
Rounding up to the nearest nickel | Excel Discussion (Misc queries) | |||
Rounding to nearest integer | Excel Worksheet Functions |