Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Help Needed......
Can anyone help me, Im trying to create a data sheet, basically I need to
enter a height value, then I need it to look at the value entered for the height and if its up to 350mm then it must add 35% to a second value, if its up to 600mm then it must add 40% to a second value and so on and on. Im not sure if i should be using lookup function or an IF function ? Any pointers would be appreaciated. Nige |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Help Needed......
Create a table in say M1:N20 with values of 0, 25%;350,40%; etc. and then
assuming the lookup value is in E1 and the value to be added to is D1, use =D1*(1+VLOOKUP(E1,M1:N20,2)) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Big Bad Nige" wrote in message ... Can anyone help me, Im trying to create a data sheet, basically I need to enter a height value, then I need it to look at the value entered for the height and if its up to 350mm then it must add 35% to a second value, if its up to 600mm then it must add 40% to a second value and so on and on. Im not sure if i should be using lookup function or an IF function ? Any pointers would be appreaciated. Nige |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Help Needed......
Thanks for the speedy reply and spot on advice !! Appreaciated.
"Bob Phillips" wrote: Create a table in say M1:N20 with values of 0, 25%;350,40%; etc. and then assuming the lookup value is in E1 and the value to be added to is D1, use =D1*(1+VLOOKUP(E1,M1:N20,2)) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Big Bad Nige" wrote in message ... Can anyone help me, Im trying to create a data sheet, basically I need to enter a height value, then I need it to look at the value entered for the height and if its up to 350mm then it must add 35% to a second value, if its up to 600mm then it must add 40% to a second value and so on and on. Im not sure if i should be using lookup function or an IF function ? Any pointers would be appreaciated. Nige |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
enable automatic refresh | Excel Worksheet Functions | |||
Excel Help Needed | Excel Worksheet Functions | |||
Is anything needed if I only load Word & Excel from Office XP Sta. | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |