Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to create an excel calculater based on the information below and am getting stuck:
Freight Rates Percentage $0.00 - $10,000.00 2.00% $10,001.00 - $50,000.00 1.50% $50,001.00 - $400,000.00 0.50% So based on the dollar of a cell i want the freight cell to calculate the amount based on the corresponding percentage. Here is the formula i was using thinking it would work but its not: =IF(H65<10,0000.00,.2,IF(H65<50,000.00,.15,IF(H65< 400,0000.00,.05))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
creating a calculator | Excel Discussion (Misc queries) | |||
freight calculator | Excel Discussion (Misc queries) | |||
creating a calculator | Excel Discussion (Misc queries) | |||
Creating a Utility Cost calculator | Excel Discussion (Misc queries) | |||
Integrated calculator in excel 07 instead of separate calculator | Excel Programming |