T
tim
All,
I'm trying to put together an application that will determine how
much more in sales are needed to move to the nest bracket. I need to do
this for 12 brackets. I understand that Nested IF statements will not
work.
From the research I have done, I see that VLOOKUP may work, but I
really don't understand the function. Below is what I'm trying to
accomplish with the Nested Loop. The cell reference is the dollar amt
of sales for the month. All help is truly appreciated.
tks
Tim
=IF(C33<150,150-C33,IF(C33<250,250-C33,IF(C33<500,500-C33,IF(C$33<750,75
0-C33,IF(C33<1000,1000-C33,IF(C33<1500,1500-C33,IF(C33<2000,2000-C33,IF(
C33<3000,3000-C33))))))))
I'm trying to put together an application that will determine how
much more in sales are needed to move to the nest bracket. I need to do
this for 12 brackets. I understand that Nested IF statements will not
work.
From the research I have done, I see that VLOOKUP may work, but I
really don't understand the function. Below is what I'm trying to
accomplish with the Nested Loop. The cell reference is the dollar amt
of sales for the month. All help is truly appreciated.
tks
Tim
=IF(C33<150,150-C33,IF(C33<250,250-C33,IF(C33<500,500-C33,IF(C$33<750,75
0-C33,IF(C33<1000,1000-C33,IF(C33<1500,1500-C33,IF(C33<2000,2000-C33,IF(
C33<3000,3000-C33))))))))