I need 1 cell to populate from other cells based on criteria.
If cell G29 is above 10 to 19.99 then it equals A31
If cell G29 is above 20 to 29.99 then it equals A32
If cell G29 is above 30 to 30.99 then it equals A33
If cell G29 is above 40 to 40.99 then it equals A34
If cell G29 is above 50 to 50.99 then it equals A35
If cell G29 is above 60 and above then it equals A36
Kinda stuck here, any help is much appreciated