Forum Discussion
Excel formula for range and value
I need to write a formula in Excel, when the Monthly Total Wage is $1000 or below, the value appearing will be $3, when the Monthly Total Wage is more than $1000 to $2000, the value appearing will be...
Wizza_Teo Create a lookup table with the lower boundaries for each bracket. Then LOOKUP can find the correct value. See attached.