Excel Help me on excel formula

Joined
Jun 18, 2005
Messages
2
Reaction score
0
FOB Value <500 500-1000 1000-2000 >2000
A 5 10 15 20
B 6 11 16 21
C 7 12 17 22
D 8 13 18 23



FOB 775


CHARGES A 10

Looking at the above chart based on each customer A,B,C & D PRICES HAVE BEEN DEFINED ACCORDING TO THE FOB VALUE RANGE. NOW I WANT TO MAKE A FORMULA WHAT WOULD BE THE CHARGES ON CHANGING THE FOB VALUE AGAINST EACH CUSTOMER.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top