Rounding

[Tony Pleasant]

If I enter an dollar value in cell A1 ($93.23) I would
like for the dollar value ($83.99) to be returned in cell
B2.

TFTH,
Tony

 

[Jonathan Cooper]

Shouldn't be a problem, but what is the relationship between 83.99 and 93.23? What do you want to happen it it's more or less than 93.23

This will do what you want, but I don't think it answers your question. =IF(A1=93.23,89.99,0

----- Tony Pleasant wrote: ----

If I enter an dollar value in cell A1 ($93.23) I would
like for the dollar value ($83.99) to be returned in cell
B2

TFTH
Ton

 

[tony pleasant]

Johathan,
Thanks for the reply and I am sorry I did not explain my
question better. What I am looking to do is to round my
A2 entry up to the next whole dollar value and then minus
(B2) 10.01, (C2) 20.01, (D2) 30.01, etc. [eg. A2 83.32
(rounded to 84.00), B2 should return 73.99, C2 should
return 63.99, D2 should return 53.99, etc.]

A1 B2 C2 D2 E2
83.32 73.99 63.99 53.99 43.99

I hope that explains my logic better.
TFTH,
Tony

-----Original Message-----
Shouldn't be a problem, but what is the relationship

between 83.99 and 93.23? What do you want to happen it
it's more or less than 93.23?

This will do what you want, but I don't think it answers

your question. =IF(A1=93.23,89.99,0)

 

[Bernard Liengme]

Does this do it: =CEILING(A1,1)-10.01 or =CEILING(A1,1)-B1

 

[Ken Wright]

In B2 put

=ROUNDUP($A1,0)-(COLUMN()-1)*10-0.01

and copy across

or even

=INT($A1)-((COLUMN()-2)*10)-9.01

and copy across

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Johathan,
Thanks for the reply and I am sorry I did not explain my
question better. What I am looking to do is to round my
A2 entry up to the next whole dollar value and then minus
(B2) 10.01, (C2) 20.01, (D2) 30.01, etc. [eg. A2 83.32
(rounded to 84.00), B2 should return 73.99, C2 should
return 63.99, D2 should return 53.99, etc.]

A1 B2 C2 D2 E2
83.32 73.99 63.99 53.99 43.99

I hope that explains my logic better.
TFTH,
Tony

-----Original Message-----
Shouldn't be a problem, but what is the relationship

between 83.99 and 93.23? What do you want to happen it
it's more or less than 93.23?

This will do what you want, but I don't think it answers

your question. =IF(A1=93.23,89.99,0)

----- Tony Pleasant wrote: -----

If I enter an dollar value in cell A1 ($93.23) I would
like for the dollar value ($83.99) to be returned in cell
B2.

TFTH,
Tony

.

 

[Bernard Liengme]

Try in B2, =ROUNDUP(A2,0)-10.01
Best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

Johathan,
Thanks for the reply and I am sorry I did not explain my
question better. What I am looking to do is to round my
A2 entry up to the next whole dollar value and then minus
(B2) 10.01, (C2) 20.01, (D2) 30.01, etc. [eg. A2 83.32
(rounded to 84.00), B2 should return 73.99, C2 should
return 63.99, D2 should return 53.99, etc.]

A1 B2 C2 D2 E2
83.32 73.99 63.99 53.99 43.99

I hope that explains my logic better.
TFTH,
Tony

-----Original Message-----
Shouldn't be a problem, but what is the relationship

between 83.99 and 93.23? What do you want to happen it
it's more or less than 93.23?

This will do what you want, but I don't think it answers

your question. =IF(A1=93.23,89.99,0)

----- Tony Pleasant wrote: -----

If I enter an dollar value in cell A1 ($93.23) I would
like for the dollar value ($83.99) to be returned in cell
B2.

TFTH,
Tony

.