Jump to content

Welcome to Geeks to Go - Register now for FREE

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
Photo

Excel formula


  • Please log in to reply

#1
B Rosen

B Rosen

    New Member

  • Member
  • Pip
  • 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

Advertisements


#2
piper

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

B Rosen

    New Member

  • Topic Starter
  • Member
  • Pip
  • 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

piper

    Retired Staff

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

#5
B Rosen

B Rosen

    New Member

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

Attached Files


  • 0

#6
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
How about this?
  • 0

#7
piper

piper

    Retired Staff

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

#8
B Rosen

B Rosen

    New Member

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

#9
piper

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

B Rosen

    New Member

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

#11
nollijible

nollijible

    Member

  • Member
  • PipPip
  • 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.

Attached Files


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP