[B Rosen]

I am trying to make a spread sheet where
if s13<0, any information added from s15-17 would be put into cel t15-t17 and a 0 value added to s15-17

Can anyone help?

Thanks so much

[Advertisements]

This would work - there may be an easier way, but...

In cell t15, place this formula
=if ($s$13<0, s15,0)

Then copy it to t16 and t17.

The '$' symbol keeps the reference to S13 static, regardless of where you copy the formula.

If that doesn't work, post back.

[piper]

This would work - there may be an easier way, but...

In cell t15, place this formula
=if ($s$13<0, s15,0)

Then copy it to t16 and t17.

The '$' symbol keeps the reference to S13 static, regardless of where you copy the formula.

If that doesn't work, post back.

[B Rosen]

not quite right
i am putting information into G (hours of work) and using =sum in S to deduct those hours so that when they reach 0 from 44 in the S column, it will put any hours i put into G after that into the overtime column which is H. i dont want any hours into G to show after S = 0.

Do i have to add the hours in another column (say p), making G the =sum of P, but then which column would I put your $s$ formula?

[piper]

Something like this?

[B Rosen]

see if this makes any sense to you.

Attached Files

•  Book1.zip   2.82KB   211 downloads

[piper]

How about this?

[piper]

Did you get the formula worked out?

[B Rosen]

nope, i am finding too many variables for it to work the way i thought it would.

[piper]

Well, if you want to post back your specific questions or problems, we'll be happy to help brainstorm a solution.

Good luck.

[B Rosen]

i will post it with a better description

[nollijible]

See attached file...

I've taken a stab at it here. A few more details would help. That 29 hours to start the week threw me.

Attached Files

•  payroll.zip   3.17KB   161 downloads