Thread: How do I enter a formula in a cell that changes per another cell's
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vijay_India Vijay_India is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote