PAGE-1

A B C D( FORMULA REQUIRED
Sl.No Location Number Cut off Level
1 S 3
2 N 45
3 E 9
4 W 55
5 S 70
6 N 10
7 S 15
8 S 50



Page-2
A B C
Location Number Cut off Level
S 1 -1
S 2 -1.150
S 3 -1.312
S 4 -1.425
S 5 -1.44
S 6 -1.52
S 7 -1.59
S 8 -1.68
S 9 -3
S 10<=74 -4.90
S 75 -10.525
E 1 -2.52
E 2 -2.78
E 3 -2.98
E 4 -3.45
E 5 -3.65
E 6 -3.85
E 7 -4.01
N 1-50 -7.90
W From 1-50 -4.90


i NEED A FORMULA IN PAGE1 COLUMN D BASED ON THE INPUT IN PAGE 2 FOR NORTH
DIRECTION WHAT EVER THE NUMBER UPTO 50 THE VALUE SHOULD BE -7.90 AND THAT OF
DIRECTION"W" IT SHOULD BE 4.90 AND FOR THE "S" 10<=75 IT SHOULD BE -4.90 AND
76 IT SHOULD BE -10.525, AND THAT OTHER NUMBER IT SHOULD BE AS PER SHEET-2