Cell values based upon multiple conditions
 

I am trying to make a spreadsheet for my business and I cant figure out one
thing. basically if cell C29 reads 2, I need cell B18 to read 50...... if
C29 reads 4, I need B18 to read 105....... if C29 is 6, B18 needs to be 165..
........... and if C29 is 8, than B18 Needs to be 230.. is there a way to
do this???

C29 B18
2 50 25*2 + 0
4 105 25*4 + 5
6 165 25*6 + 15
8 230 25*8 + 30

Can you be more specific as to how the numbers are derived or are you
asking for a guess at a progression.


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ryan M via OfficeKB.com" wrote in message ...

I am trying to make a spreadsheet for my business and I cant figure out one
thing. basically if cell C29 reads 2, I need cell B18 to read 50...... if
C29 reads 4, I need B18 to read 105....... if C29 is 6, B18 needs to be 165..
.......... and if C29 is 8, than B18 Needs to be 230.. is there a way to
do this???

Enter this in B18:

=VLOOKUP(C29,{2,50;4,105;6,165;8,230},2,0)

Is this what you're looking for?
--
HTH,

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



"Ryan M via OfficeKB.com" wrote in message
...

I am trying to make a spreadsheet for my business and I cant figure out
one
thing. basically if cell C29 reads 2, I need cell B18 to read 50...... if
C29 reads 4, I need B18 to read 105....... if C29 is 6, B18 needs to be
165..
.......... and if C29 is 8, than B18 Needs to be 230.. is there a way
to
do this???