+ Reply to Thread
Results 1 to 3 of 3

Can IF function result in its answer in a different cell?

  1. #1
    Registered User
    Join Date
    01-15-2010
    Location
    cincinnati
    MS-Off Ver
    Excel 2000
    Posts
    7

    Can IF function result in its answer in a different cell?

    Can this Formula work? Where if c2<e5 then its value is a number.
    The formula below is what i tried but it didnt work

    =IF((C2<E5);"c5=value=f5")
    Last edited by donaldberends; 01-15-2010 at 08:21 PM.

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Can IF function result in its answer in a different cell?

    A formula can only put a result in the cell in which it resides. If you want C5 to be the same as F5 if C2 < E5 then put this formula in C5:

    IF(C2<E5;F5;"")

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,160

    Re: Can IF function result in its answer in a different cell?

    Hi,

    Try

    Please Login or Register  to view this content.
    where the result is the F5 value if C2 is less than E5, otherwise blank

    HTH
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

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