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......

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......

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......

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......