#### Utradeshow

##### Well-known Member

- Joined
- Apr 26, 2004

- Messages
- 800

- Office Version
- 365

I need the formula in cell in I2. Would it better to do a macro? for this result?

If Miles 1-400 and G = 1 then 15%

If Miles 1-400 and G = 2 then 8.5%

If miles 401-600 and G = 1 then 20.2%

IF Miles 401-600 and G= 2 then 13%

If Miles 601 > and G = 1 or 2 then 13%

If G = 3 then 0%

BVL Accrual Master.xls | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|

A | B | C | D | E | F | G | H | I | |||

1 | Name | LoadDate | Waybill | COD=1DOD=2CORP=3D&E=4 | RatedNetLinehaul | Miles | SelfHaul=1Booker/OA=2HaulerOnly=3 | Booking | Bkg% | ||

2 | $0.00 | ||||||||||

3 | |||||||||||

4 | IfMiles1-400andG=1then15% | ||||||||||

5 | IfMiles1-400andG=2then8.5% | ||||||||||

6 | Ifmiles401-600andG=1then20.2% | ||||||||||

7 | IFMiles401-600andG=2then13% | ||||||||||

8 | IfMiles601>andG=1or2then13% | ||||||||||

9 | IfG=3then0% | ||||||||||

10 | |||||||||||

Waybill Detail |