Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# Excel formula

### #1 B Rosen Posted 07 December 2006 - 01:50 PM

B Rosen

New Member

• Member
• 5 posts
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
• 0

### #2 piper Posted 07 December 2006 - 02:03 PM

piper

Retired Staff

• Retired Staff
• 2,459 posts
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.
• 0

### #3 B Rosen Posted 07 December 2006 - 02:13 PM

B Rosen

New Member

• Topic Starter
• Member
• 5 posts
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?
• 0

### #4 piper Posted 07 December 2006 - 02:22 PM

piper

Retired Staff

• Retired Staff
• 2,459 posts
Something like this?
• 0

### #5 B Rosen Posted 07 December 2006 - 02:55 PM

B Rosen

New Member

• Topic Starter
• Member
• 5 posts
see if this makes any sense to you.

• 0

### #6 piper Posted 07 December 2006 - 03:24 PM

piper

Retired Staff

• Retired Staff
• 2,459 posts
• 0

### #7 piper Posted 13 December 2006 - 03:50 PM

piper

Retired Staff

• Retired Staff
• 2,459 posts
Did you get the formula worked out?
• 0

### #8 B Rosen Posted 13 December 2006 - 03:51 PM

B Rosen

New Member

• Topic Starter
• Member
• 5 posts
nope, i am finding too many variables for it to work the way i thought it would.
• 0

### #9 piper Posted 13 December 2006 - 03:56 PM

piper

Retired Staff

• Retired Staff
• 2,459 posts
Well, if you want to post back your specific questions or problems, we'll be happy to help brainstorm a solution.

Good luck.
• 0

### #10 B Rosen Posted 13 December 2006 - 04:01 PM

B Rosen

New Member

• Topic Starter
• Member
• 5 posts
i will post it with a better description
• 0

### #11 nollijible Posted 15 December 2006 - 03:58 PM

nollijible

Member

• Member
• 25 posts
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.

• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users