Help with a formula please.

John Gill

New Member
Joined
Jul 7, 2002
Messages
7
I'm using an IF statement eg =IF(A20<1000,10,IF(A20<10000,20)),
within the list of the numbers 1 - 10000, certain numbers within the range, for which I have a list, I would like defaulted to say 50.

I dont know if a vlookup table, can be embedded within my current formula, or if there is another formula that will provide me with the answer.

Kind Regards
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
in general:

set up a lookup table such that the left hand column has the lowest value for each class, and the right hand column the value to return for the class, then use a formula of the form:

=vlookup(item,lookup_table,2)
 

Watch MrExcel Video

Forum statistics

Threads
1,111,911
Messages
5,541,543
Members
410,549
Latest member
Anaarchie
Top