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

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

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

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

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

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