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 $4.50 and so on, as seen in the photo below. How may I formulate this in one formula?
1 Reply
Wizza_Teo Create a lookup table with the lower boundaries for each bracket. Then LOOKUP can find the correct value. See attached.
