# 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. ## 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. ## Re: different answers for different conditions in one formul

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

3. ## Re: different answers for different conditions in one formul

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

#### Posting Permissions

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