Excel Formula Request

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

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

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

6 yrs ago I could have helped you, now the stuff just looks foreign to me. I have asked a couple of my friends though. If they have a solution I will post it here for ya.

 

Not sure if this will work, and I am too lazy to test it, but it sounds like you are looking for an IF/AND statement like

=IF(AND(S13<0,(T15:T17=S13+S15:S17),(S15:S17=0)))

It has been at least 5 years since I was really into the Excel, but this might get you at least in the ballpark.

 

brosen,

Questions:

1. What do you mean by "...any information added from s15-17?" Are you talking about any data change in cells S15 through S17?
2. What do you mean by "...and a 0 value added to s15-17?"
3. What is located at s13, data or equation?
4. If S13 is data, what does the data in cell S13 mean? In other words, what are the units for the data in cell S13?
5. If S13 is an equation, what is the equation?
6. What are you trying to accomplish overall with this spreadsheet?

 

Try Mrexcel.com

Used the site many times for complex fault finding. Post on that forum and you'll get an answer back in minutes!!

Hope it helps.