+ Reply to Thread
Results 1 to 2 of 2

Thread: IF True result in different cell

  1. #1
    Registered User
    Join Date
    11-01-2011
    Location
    USA
    MS-Off Ver
    Excel 2004 for Mac
    Posts
    41

    IF True result in different cell

    I'd like to have the True value of my IF statement placed into a different cell or cells. How would your write that?

    For example, here is a code that is not working:

    =IF(OR($F38="36x48 POD size",$F38="30x40 POD size",$F38="42x56 Pod size",$F38="48x64 Pod size"),H38:H99 "XL Moab","")
    Thanks very much.

  2. #2
    Valued Forum Contributor MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    5,285

    Re: IF True result in different cell

    Hi firehousetk,

    I think the "H38:H99" part of your formula is the problem. The formula can't return a range to a single cell.
    One test is worth a thousand opinions.
    Click the * below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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.2.0