Greater than Less than in embedded IF statement

**CMTench** · 03-18-2010, 03:39 PM

I have 3 different percentages to multiply one number by, based upon the value being within certain ranges. I can't seem to figure out how to say if(B10 is greater than, or less than x, +B10*22.5)

Can someone help me figure out what the correct formula should be in column E?

**shg** · 03-18-2010, 03:41 PM

The workbook is password-protected.

**CMTench** · 03-18-2010, 03:44 PM

sorry - you can use "ferrari" to open it

**Larry.LeBlanc@O** · 03-18-2010, 06:43 PM

In G6 I entered: =B6*VLOOKUP(B6,$K$4:$L$7,2). I then copied this down.

In K4:L7 I entered the VLookup range:
0 17.50%
500,000 20.00%
999,999 22.50%
1,999,999 NA (I am not sure of the value to use for numbers greater than 1,999,999)

**CMTench** · 03-19-2010, 10:50 AM

Originally Posted by Larry.LeBlanc@O

In G6 I entered: =B6*VLOOKUP(B6,$K$4:$L$7,2). I then copied this down.

In K4:L7 I entered the VLookup range:
0 17.50%
500,000 20.00%
999,999 22.50%
1,999,999 NA (I am not sure of the value to use for numbers greater than 1,999,999)

Thank you - that will work.