embedded equations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make an equation that will increment once a value is met and then
add it to a total. Say - I start with the value 2 when X is < 250 if X
goes > 250 add 1 to the total so now the total would be 3, if X is 500 then
add another 1 to the total, if X is > 750 then add another 1 to the total so
now the total is 4 and so on with each inrement of 250.
 
Need more info.
IS X a value you type into a single or is there a column of X values?
In the "total" a single value of a column of values?
What is the formula for Total?

Best wishes
Bernard
 
If X is cell A1, does this do what you wish?

=LOOKUP(A1,{1,250,500,750,1000,1250},{2,3,4,5,6,7})
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I need to make an equation that will increment once a value is met and then
add it to a total. Say - I start with the value 2 when X is < 250 if X
goes > 250 add 1 to the total so now the total would be 3, if X is 500 then
add another 1 to the total, if X is > 750 then add another 1 to the total so
now the total is 4 and so on with each inrement of 250.
 
Back
Top