# Multiple Function same formula

#### DCAbound

##### New Member
I wonder if anyone can help with this. I now know that + is actually equates to OR. I am trying to write an argument that states...

How would I change this?

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### cyrilbrd

##### Well-known Member
Hi, do you want TRUE if A1+B1+B2+B3+B4 superior or equal to 3?

#### mikerickson

##### MrExcel MVP
can you describe in words what results you want from what inputs

#### DCAbound

##### New Member
I am trying to create decision text for a questionnaire. Responses for columns A-F are 1 or blank since they are answers to a Check all that applies. Column g responses are 1-4 as it is a radio button. Below is the highlighted description of what i need to accomplish.

 A B c d e f g EXAMq28a EXAMq28b EXAMq28c EXAMq28d EXAMq28e EXAMq28f EXAMq29 Rep1 1 1 1 1 1 Advance Rep2 1 1 1 2 Advance Rep3 1 1 3 Advance Rep4 1 4 Latent Rep5 1 Latent Rep6 1 1 1 1 1 Advance Rep7 1 2 Latent Rep8 1 3 Advance Rep9 1 4 Latent Rep10 Latent Rep11 Latent Rep12 1 Latent Rep13 1 1 1 1 Advance Rep14 Rep15 Q28 Q29 A:D>=3 1 Advance A:D>=3 2 Established A:D>=2 3 Emerging 28F=1 and ELSE Latent

<!--StartFragment--> <colgroup><col width="69" style="width:69pt"> <col width="69" span="7" style="width:69pt"> <col width="69" style="width:69pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

#### DCAbound

##### New Member
These are the text that I need to show once the value is true

 Q28 Q29 A:D>=3 1 Advance A:D>=3 2 Established A:D>=2 3 Emerging E=1 and ELSE 4 Latent

<!--StartFragment--> <colgroup><col width="69" span="3" style="width:69pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

#### mikerickson

##### MrExcel MVP
Perhaps something like
=CHOOSE(Q29, IF(A:D>=3, "Advance", "not specified") , IF(A:D>=3,"Established", "not specified") , IF(A:D>=2, "Emerging", "not specified") , IF(E1=1, "Latent", "not specified"))

You'd have to substitue the correct syntax for A:D>=3,2 etc. and also resolve the "not specified" conditions. (Your chart doesn't specify what you want if Q29=1 and A:D < 3)

The main notion is to use CHOOSE(Q29,....) to split out those possibilities. Each of the other arguments of CHOOSE should be a formula appropriate for that value of Q29.

Last edited:

#### DCAbound

##### New Member
It shows me a value error.

Here is the formula i used.

 A B c d e f g EXAMq28a EXAMq28b EXAMq28c EXAMq28d EXAMq28e EXAMq28f EXAMq29 Rep1 1 1 1 1 1 #VALUE! Rep2 1 1 1 2 #VALUE!

<!--StartFragment--> <colgroup><col width="69" style="width:69pt"> <col width="69" span="7" style="width:69pt"> <col width="69" style="width:69pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

#### cyrilbrd

##### Well-known Member
It shows me a value error.

Here is the formula i used.

 A B c d e f g EXAMq28a EXAMq28b EXAMq28c EXAMq28d EXAMq28e EXAMq28f EXAMq29 Rep1 1 1 1 1 1 #VALUE! Rep2 1 1 1 2 #VALUE!

<tbody>
</tbody>
1-Entered CSE.
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { vertical-align: middle; white-space: normal; }.xl64 { text-align: right; vertical-align: middle; white-space: normal; }.xl65 { font-family: "Lucida Grande"; }</style>
 A B c d e f g EXAMq28a EXAMq28b EXAMq28c EXAMq28d EXAMq28e EXAMq28f EXAMq29 Rep1 1 1 1 1 1 1 Rep2 1 1 1 2 2

<tbody>
</tbody>

#### DCAbound

##### New Member
Why would it be H3? Shouldn't it be G3? Formula still doesn't work showing a value error

#### cyrilbrd

##### Well-known Member
sorry, yes ...
my columns are off by 1 value... B3:E3 should be A3:D3...