I would like to create a sales order form that calculates a total of the unit
price, sales tax and S&H. S&H varies according to the number of units
purchased. I am using excel 2003.
I would like to create a sales order form that calculates a total of the unit
price, sales tax and S&H. S&H varies according to the number of units
purchased. I am using excel 2003.
You can use the "IF" function up to seven times.
Below is an example for Cell A2 <10 and > than 10 - each time you come
to the"false" value just click on the "IF" Function again - up to seven
times.
=IF(A2<10,A2*8.5,IF(A2>10,A2*6.5))
--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2298332
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks