Results 1 to 3 of 3

different answers for different conditions in one formula

This is a discussion on different answers for different conditions in one formula within the Excel Questions forums, part of the Question Forums category; I'm back.... This one has drove me nuts....I need to return different results for different conditions within a single cell. ...

  1. #1
    New Member
    Join Date
    Feb 2003
    Posts
    8

    Default different answers for different conditions in one formula

    I'm back....
    This one has drove me nuts....I need to return different results for different conditions within a single cell. (eg., IF (k7=10,300,0)
    IF (k7=20,400,0)
    IF (k7=30,500,0)

    I want to have ALL of these conditions in one formula, in one cell. Nothing I've tried in HELP seems to work. Thanks.

    The Village Idiot :D

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    61,998

    Default Re: different answers for different conditions in one formul

    =100*((K7=10)*3+(K7=20)*4+(K7=30)*5)

  3. #3
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,880

    Default Re: different answers for different conditions in one formul

    Quote Originally Posted by rvanover
    I'm back....
    This one has drove me nuts....I need to return different results for different conditions within a single cell. (eg., IF (k7=10,300,0)
    IF (k7=20,400,0)
    IF (k7=30,500,0)

    I want to have ALL of these conditions in one formula, in one cell. Nothing I've tried in HELP seems to work. Thanks.

    The Village Idiot :D
    =IF(K7=10,300,IF(K7=20,400,IF(K7=30,500,0)))

    Eli

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com