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

[Bev Greene]

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

 

[Vijay_India]

Use the "If" function.

=if(sales<200,15,25)

Do let me know if you need additional tips.

thanks,

 

[Dave F]

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

 

[Paul B]

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

 

[NOY-PI]

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

 

[NOY-PI]

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.