Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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??? |
#2
|
|||
|
|||
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??? |
#3
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
generate multiple rows based on cell value | Excel Worksheet Functions | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
Toggle multiple values in single cell | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |