Cell values based upon multiple conditions

  • Thread starter Thread starter Ryan M via OfficeKB.com
  • Start date Start date
R

Ryan M via OfficeKB.com

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.
 
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!
==============================================
 
Back
Top