Using Formulas

F

fshewmkr

I want to be able to add across using a formula so that if cell c4 is 8R4OT
and cell d4 is 4S4R and cell e4 is 8V then cell j4 is 12 and cell k4 is 4 and
cell L4 is 4 and so on please help.
 
J

JLatham

Your previous post just below this one in this formum, a
http://www.microsoft.com/office/com...ions&mid=4f0c7209-1487-4dc4-869b-89c18f5d02ca
actually explains it a little better.

It's a timesheet problem folks! 4R = 4 hrs regular, 4S = 4 hrs Sick, 4OT =
4 hrs overtime, 8V = 8 hrs vacation etc. or so I presume.

fshewmkr, you really are better off using more rows instead of trying to put
everything into one cell. I'd rearrange the timecard so that you can record
the various types of hours in different Rows. Things become much easier then.

Consider a layout something like this, which is good for one employee, not
quite as good for multiple employees on the same sheet, but can be adapted to
work that way.

Column A B C D E F G H I J
row 1 name ID M T W Th F S S total
row 2 regular hours # # # # # # # ##
row 3 overtime # # # # # # # ##
row 4 vacation # # # # # # # ##
row 5 sick .... etc, etc

Row #? next name ID ...........



Having the possiblity of multiple types of times in a single cell makes it
one hell of a complicated mess to deal with.
 
B

Bernard Liengme

Please explain where the 12, 4 and 4 come from.
It is not obvious to me
best wishes
 
D

David Biddulph

A formula puts a value into one cell.

In cell J4 you want the formula
=IF(AND(c4="8R4OT",d4="4S4R",e4="8V"),12,"whatever you want the answer to be
if the AND condition isn't satisfied")
In K4 you want
=IF(AND(c4="8R4OT",d4="4S4R",e4="8V"),4,"whatever you want the answer to be
if the AND condition isn't satisfied")
In L4 you want
=IF(AND(c4="8R4OT",d4="4S4R",e4="8V"),4,"whatever you want the answer to be
if the AND condition isn't satisfied")
and so on.
 

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