Results 1 to 4 of 4

Double if

Threaded View

TRS Double if 01-16-2012, 01:31 PM
Andrew-R Re: Double if 01-16-2012, 01:33 PM
NBVC Re: Double if 01-16-2012, 01:34 PM
TRS Re: Double if 01-16-2012, 01:56 PM
  1. #1
    Registered User
    Join Date
    05-18-2010
    Location
    Europe
    MS-Off Ver
    Excel 2010
    Posts
    54

    Double if

    Hi guys,

    I hope you can help me.

    now I have this formula

    =IF(B2>1,1,0)

    but I discovered there is another paramiter that I have to consider. Basically if A2=Y this formula is still valid. If A2=N the formula should be =IF(B2>2,1,0)
    Should be something like what I have written below. I have also attached a file. Maybe it helps.

    IF A2=Y THEN C2="IF(B2>2,1,0)"
    IF A2=N THEN C2="IF(B2>1,1,0)"

    Let me know if something is not clear.
    Thanks in advance for your help!!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1