Thread: if statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ruth Ruth is offline
external usenet poster
 
Posts: 132
Default 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