Kulo5856
New Member
- Joined
- May 11, 2020
- Messages
- 36
- Office Version
- 365
- 2013
- 2010
- Platform
- Windows
- Mobile
- Web
Hi all, I need formula for a condition which the column A,B,C,D and i need total charges for the shipment weight
i used formula =IF(N3>=251,N3*2,IF(N3>=101,N3*1)) for single cell but i need for all cells
If weight morethan 101 multiply by 1 and weight more than 251 multiply by 2, then final result need to add total charges
i used formula =IF(N3>=251,N3*2,IF(N3>=101,N3*1)) for single cell but i need for all cells
If weight morethan 101 multiply by 1 and weight more than 251 multiply by 2, then final result need to add total charges
Shipment weight | Total charges | |||
A | B | C | D | |
35 | 115 | 256 | 320 | |
93 | 168 | 451 | 680 | |
296 | 325 | 105 | 222 |