Otispunkmeyer
New Member
- Joined
- Oct 2, 2006
- Messages
- 8
=IF(699>D2,$S$2,IF(799>D2,$S$3,IF(899>D2,$2$4)))
its actually longer, but it just keeps going ie 999>D2, 1099>D2, 1199>D2 etc
what does it do? the previous guy who worked on what im working on now has written this down as a method of sorting data, and as good as he has been writing it down, he hasnt explained what the hell it does.
does it find if numbers are bigger than 699 and less than 799 then it sums them up in a new box?
its actually longer, but it just keeps going ie 999>D2, 1099>D2, 1199>D2 etc
what does it do? the previous guy who worked on what im working on now has written this down as a method of sorting data, and as good as he has been writing it down, he hasnt explained what the hell it does.
does it find if numbers are bigger than 699 and less than 799 then it sums them up in a new box?