Exel formating

[reliancekop]

dear all i am new here and i want one excel sheet with some formating conditions here are the details of sheet

A B C D E F
1 RATE AMOUNT TEAM L OR K 1=INDIA 2= ENGLAND
2 0.85 10000 INDIA L +8500 -10000
3 0.40 13000 INDIA K -5200 +13000
4 0.75 6000 ENGLAND L -6000 + 4500
5 0.22 8000 ENGLAND K +8000 - 1760
6
7 TOTAL +5300 +5740

IN ABOVE SHEET DATA IN CELL NO E1 AND F1 WILL BE KEEPING CHANGING NOW IN ABOVE Eg E1 =1= INDIA AND F1=2 = ENGLAND

DATA IN CELL NO A2 B2 C2 D2 WILL CHANGING DATA AND WILL BE FEED BY MYSELF.
WHAT I WANT IS THAT FIGURES IN CELL E2 AND F2 SHOULD BE COMMING AUTOMATICALLY
CASE 1 :
WHEN I INPUT DATA IN A2,B2,C2 AND D2 AND RESULT SHOULD BE AS ABOVE SHEET. THAT IS IF IN CELL A2 RATE INPUT VALUE IS 0.85,IN CELL B2 AMOUNT VALUE IS 10000, IN CELL C2 TEAM IS INDIA,AND IN CELL D2 WE PUT TEXT AS " L " THEN RESULT WE SHOULD GET IN CELL E2 SHOULD BE A2 X B2 THAT IS 0.85 X 10000 THAT IS 8500 AND AT THE SAME TIME RESULT IN F2 SHUULD BE NEGAVITE VALUE OF VALUE IN B2 THAT IS -B2 MEAN RESULT IN F2 WILL BE -10000 SUPPOSE WE INPUT "K" INSTEAD OF "L" IN D2 VALUES IN THE CELLS E2 AND D2 WILL CHANGE THERE SIGN BE VALUE THAT IS VALUE IN E2 WILL BE -8500 AND VALUE IN F2 WILL BE +10000.

[martindwilson]

1 Please do not post in Caps
2 Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic