+ Reply to Thread
Results 1 to 3 of 3

To give a solution in another cell

  1. #1
    Registered User
    Join Date
    05-15-2008
    Posts
    38

    To give a solution in another cell

    Hi,
    how could I make a formula where I obtain a solution in another cell?

    For example, I have this data:

    A B
    4 7

    and I put in C2 a formula where I say that if the result of add A2 to B2 is 11 I want in D4 the number 15. How could I make it?

    I wrote this:

    =if(A2+B2=11;D4=15;0)
    but it doesn't work.

    Thank you very much

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    you need to put the formula in d4 itself
    =if(A2+B2=11;15;0)

  3. #3
    Registered User
    Join Date
    05-15-2008
    Posts
    38
    Ok,
    thank you very much.

+ 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