+ Reply to Thread
Results 1 to 4 of 4

if formula with 4 columns

Hybrid View

  1. 06-09-2014, 06:31 PM #1
    sthshrmags
    sthshrmags is offline
    Registered User
    Join Date
    06-09-2014
    MS-Off Ver
    13
    Posts
    7

    if formula with 4 columns

    Hello,
    hoping you can help me.

    i would like to add to the basic if statement in my attached column M to say if the result of this if statement is 0 then give me Q.

    The statement i currently have is =if(p2=0,n2,p2)

    I am sure this is simple but i have been staring at this formula for so long today i can't see it.

    i always found this forum helpful.

    i appreciate it.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-09-2014, 06:52 PM #2
    gak67
    gak67 is offline
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: if formula with 4 columns

    Formula: copy to clipboard 
    =if(if(p2=0,n2,p2)=0,q2,if(p2=0,n2,p2))
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.
    Reply With QuoteRegister To Reply
  3. 06-10-2014, 12:03 AM #3
    boopathiraja
    boopathiraja is offline
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: if formula with 4 columns

    try this

    =IF(IF(P2=0,N2,P2)=0,Q2,"")
    ☚ Click ★ just below left if it helps, Boo?ath?
    Reply With QuoteRegister To Reply
  4. 06-10-2014, 12:29 AM #4
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: if formula with 4 columns

    Another....

    =IF(AND(P2=0,N2=0),Q2,IF(P2=0,N2,P2))
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel formula to copy data from several columns in Sheet1 to several columns in Sheet2
    By ic3cold in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-22-2014, 08:10 AM
  2. Need to define pairs in two columns and then build formula to compare these columns
    By tamara82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-30-2013, 04:58 PM
  3. Increment columns in INDEX and MATCH formula - ROWS and COLUMNS
    By nickmangan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2012, 10:38 AM
  4. Formula to extracting columns values which fulfills criteria of other columns
    By bholya in forum Excel General
    Replies: 1
    Last Post: 04-06-2012, 12:24 AM
  5. Formula to align two columns with nearly similar text and attached numeric columns
    By Benefits Recon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2012, 12:03 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1