1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel Formula Request

Discussion in 'Microsoft Office Specialist (MOS)' started by brosen, Dec 7, 2006.

  1. brosen

    brosen New Member

    1
    0
    1
    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
     
  2. Mitzs
    Honorary Member

    Mitzs Ducktape Goddess

    3,282
    73
    152
    6 yrs ago I could have helped you, now the stuff just looks foreign to me.:D I have asked a couple of my friends though. If they have a solution I will post it here for ya.
     
    Certifications: Microcomputers and network specialist.
    WIP: Adobe DW, PS
  3. mrobinson52

    mrobinson52 Security Maven Gold Member

    194
    9
    74
    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.
     
    Certifications: A+, Network+, MCSA:Security, Security+
    WIP: CISSP
  4. r.h.lee

    r.h.lee Gigabyte Poster

    1,011
    52
    105
    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?
     
    Certifications: MCSE, MCP+I, MCP, CCNA, A+
    WIP: CCDA
  5. C_Eagle

    C_Eagle Byte Poster

    147
    0
    38
    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.
     
    Certifications: A+, MCP, MCDST, 70-270
    WIP: MCSA 70-290

Share This Page

Loading...