Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement
Hi there
I have a file to calculated costs that depend on time in a location. The cells look something like this: A1 A2 A3 A4 A5 1 less than 12 hours 10222 .027 =A3*A4 2 12<24 hours 10222 .012 =B3*B4 3 24<48 hours 10222 .005 =C3*C4 4 48 hours 10222 .005 =D3*D4 I have a cell where the user will select the corresponding number (1,2,3 or 4) I want a cell that will calculated the total according to the number that the user puts into the cell. If the totals are culmative, ei, if "1" then = A5 if "2" then = A5+B5 if "3" then = A5+B5+C5 if "4" then = A5+B5+C5+D5 How do a do this? -- Thank-you! Ruth |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions |