R
Ruth
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?
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?