Excel formula

cmill · May 7th, 2002, 05:52 PM

I am making a pricelist of thousands of items from a distributor of mine. One column has my cost and the other column is blank for me to put in my sale price. I am trying to figure out how to make a formula that will add 10.00 to the cost and round up the change to .95 cents. Can anyone help??

Thanks
Chris

Qroozn · May 7th, 2002, 05:58 PM

read below postings

[ This Message was edited by: Qroozn on 2002-05-07 17:30 ]

Barrie Davidson · May 7th, 2002, 06:01 PM

Quote:

On 2002-05-07 16:52, cmill wrote:
I am making a pricelist of thousands of items from a distributor of mine. One column has my cost and the other column is blank for me to put in my sale price. I am trying to figure out how to make a formula that will add 10.00 to the cost and round up the change to .95 cents. Can anyone help??

Thanks
Chris

How about:

=A1+10+IF(0.95-(A1-INT(A1))<0,1.95-(A1-INT(A1)),0.95-(A1-INT(A1)))

This assumes that if your cost is something like 10.99, your selling price would be 21.95 and not 20.95. If you want it to be 20.95, use this:

=INT(A1)+10.95

Regards,

cmill · May 7th, 2002, 06:18 PM

Thank you for your quick responses. But I am still unable to make them work. Maybe if I put in the formula that is already in the spreadsheet it will help you tell me where I'm going wrong? The way it is set up is as follows: column 1 goes vertical and numerically. Horizontally is alphabetically with A thru H with G being cost and H being retail price. Here is an example of column 880 H.

=($G880+$H$1)/(1-H$2)

How should I imput the formulas you provided?

Thanks again,

Chris

Yogi Anand · May 7th, 2002, 06:24 PM

Quote:

On 2002-05-07 17:18, cmill wrote:
Thank you for your quick responses. But I am still unable to make them work. Maybe if I put in the formula that is already in the spreadsheet it will help you tell me where I'm going wrong? The way it is set up is as follows: column 1 goes vertical and numerically. Horizontally is alphabetically with A thru H with G being cost and H being retail price. Here is an example of column 880 H.

=($G880+$H$1)/(1-H$2)

How should I imput the formulas you provided?

Thanks again,

Chris

If your cost is in cell G2. then put the following in H2

=INT(G2)+10.95
and copy it to other cells in column H

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 05:52 PM	#1
cmill New Member Join Date: May 2002 Posts: 2	I am making a pricelist of thousands of items from a distributor of mine. One column has my cost and the other column is blank for me to put in my sale price. I am trying to figure out how to make a formula that will add 10.00 to the cost and round up the change to .95 cents. Can anyone help?? Thanks Chris

May 7th, 2002, 05:58 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	read below postings [ This Message was edited by: Qroozn on 2002-05-07 17:30 ]

May 7th, 2002, 06:18 PM	#4
cmill New Member Join Date: May 2002 Posts: 2	Thank you for your quick responses. But I am still unable to make them work. Maybe if I put in the formula that is already in the spreadsheet it will help you tell me where I'm going wrong? The way it is set up is as follows: column 1 goes vertical and numerically. Horizontally is alphabetically with A thru H with G being cost and H being retail price. Here is an example of column 880 H. =($G880+$H$1)/(1-H$2) How should I imput the formulas you provided? Thanks again, Chris