if statement

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?
 
S

Sheeloo

One ro
Somewhere on your sheet put these in (Say E1:F4) numbers in Col E and
Formulas in Col F
1 =A5
2 =A5+B5
3 =A5+B5+C5
4 =A5+B5+C5+D5

Then assuming you have 1 or 2 or 3 or 4 in A7, enter this in B7
=VLOOKUP(A7,$E$1:$F$4,2,FALSE)
and copy down...
 
R

Ruth

Thank-you very much!
--

Ruth


Sheeloo said:
One ro
Somewhere on your sheet put these in (Say E1:F4) numbers in Col E and
Formulas in Col F
1 =A5
2 =A5+B5
3 =A5+B5+C5
4 =A5+B5+C5+D5

Then assuming you have 1 or 2 or 3 or 4 in A7, enter this in B7
=VLOOKUP(A7,$E$1:$F$4,2,FALSE)
and copy down...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top