Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 213
Default Formula with 3 conditions

Need a formula whereby three conditions are met to return a result.
For example, If A10 and A20 and A30, then F1+F2. If A1<0 and A20
and A30, then F1+F3, etc.


There are 8 possibilities, if my understanding of the problem is correect.

One approach is to start with the formula below. It returns a text string
for each of the possibilities, showing which ones of the three input values
are positive.

=CHOOSE((N(A1)0)+2*(N(A2)0)+4*(N(A3)0)+1,
"none","A1","A2","A1&A2","A3","A1&A3","A2&A3","all ")

For your problem, you would replace each of the text strings with the
corresponding formula.

In this formula, input cells containing text are considered "not 0";
likewise for empty cells and logical FALSE. Dates are considered "0";
likewise for logical TRUE. If that's not what's required, adjust
accordingly.

Also, the requirements seem vague for when input value(s) are exactly zero,
so adjust the formula based on what's wanted in those cases.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
two conditions formula michelledean via OfficeKB.com Excel Discussion (Misc queries) 2 February 21st 07 05:19 PM
IF formula for 3 possible conditions cbgraphics Excel Discussion (Misc queries) 6 December 28th 06 02:22 PM
Formula With Several Conditions Chris Excel Worksheet Functions 1 November 14th 06 01:38 PM
If formula with 12 conditions tkacoo Excel Discussion (Misc queries) 5 April 7th 05 04:54 PM
Help for a formula using two conditions harwookf Excel Worksheet Functions 7 November 24th 04 08:21 AM


All times are GMT +1. The time now is 11:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"