here is what I want to do.....I want to type a percentage into a1 I want b1 to have about 6 different range values and if a1 is in between a certain range it puts a predetermined number in c1
example
A1
a percentage number example 17%
B1
should have ranges like if A1 is between 16%-20% the value is 2 if a1 is between 21%-25% the value is 3 and so on
C1
should contain the predertimined value given to the ranges put into b1
anyone that can help me with this is very much appreciated
Bookmarks