How do I enter a formula in a cell that changes per another cell's
 

I am making a invoice template. The shipping will be $15 if the sales are
less than $200 and $25 for all orders $200 and over. What formula do I enter?

Thanks
Bev

How do I enter a formula in a cell that changes per another cell's
 

Use the "If" function.

=if(sales<200,15,25)

Do let me know if you need additional tips.

thanks,

"Bev Greene" wrote:

I am making a invoice template. The shipping will be $15 if the sales are
less than $200 and $25 for all orders $200 and over. What formula do I enter?

Thanks
Bev

How do I enter a formula in a cell that changes per another cell's
 

Assume sales are in A1.

Then =IF(A1<200,A1+15,A1+25)

In English: "IF A1 is less than $200, THEN A1 + $15, ELSE A1 + $25"

Dave
--
Brevity is the soul of wit.


"Bev Greene" wrote:

I am making a invoice template. The shipping will be $15 if the sales are
less than $200 and $25 for all orders $200 and over. What formula do I enter?

Thanks
Bev

How do I enter a formula in a cell that changes per another cell's
 

Bev, something like this, =IF(A1=200,25,15)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Bev Greene" wrote in message
...
I am making a invoice template. The shipping will be $15 if the sales are
less than $200 and $25 for all orders $200 and over. What formula do I
enter?

Thanks
Bev

How do I enter a formula in a cell that changes per another ce
 

sorry, im confused, an invoice has a total sum. Does the word sales $200<
means your product/goods ? Does the invoice total amount include goods +
shipping per piece (by volume or weight). Cause shipping 1000 goods with unit
saleprice of over $200 may not be logical to have $25 shipment cost
only....Really confused...

"Paul B" wrote:

Bev, something like this, =IF(A1=200,25,15)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Bev Greene" wrote in message
...
I am making a invoice template. The shipping will be $15 if the sales are
less than $200 and $25 for all orders $200 and over. What formula do I
enter?

Thanks
Bev

How do I enter a formula in a cell that changes per another ce
 

excuse me Bev...I cant handle the checked mark on an inquiry that is not
answered...please allow others to see the real task that you need
specifically.

"NOY-PI" wrote:

sorry, im confused, an invoice has a total sum. Does the word sales $200<
means your product/goods ? Does the invoice total amount include goods +
shipping per piece (by volume or weight). Cause shipping 1000 goods with unit
saleprice of over $200 may not be logical to have $25 shipment cost
only....Really confused...

"Paul B" wrote:

Bev, something like this, =IF(A1=200,25,15)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Bev Greene" wrote in message
...
I am making a invoice template. The shipping will be $15 if the sales are
less than $200 and $25 for all orders $200 and over. What formula do I
enter?

Thanks
Bev