# Multiple If fuction help needed

##### New Member

i. if the return is 10% and more, and the return is 15% and more, the decision criteria is classified as “favorable”
ii. if the following criteria is met, then the decision criteria is classified as “consider”
a) a total return on each asset of 12%, or
b) a investment of 15% return, and at least a 5% global return, or
c) a total return of 15% but a global return of less than 10%
iii. if none of the criteria is met in “i” and “ii”, then the decision criteria is classified as “do not consider”.

Thanks

Last edited:

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Hi..

Which cells are your criteria in?

I think this line is incorrect..

i. if the return is 10% and more, and the return is 15% and more, the decision criteria is classified as “favourable”

Welcome to MrExcel.

Please post some sample data and the expected results.

i. if the return is 15% and more then the return is always 10% and more, there's no AND about it.
You need to explain this more clearly.

It would help if you supply a dummy spreadsheet

 Asset Return Investment Global Return Global Investment Total return Decision criteria 50% 50% 1001 8,3 4,2 2,0 1,0 5,2 1002 6,0 3,0 11,0 5,5 8,5 1003 8,8 4,4 21,0 10,5 14,9 1004 12,5 6,3 24,0 12,0 18,3

<colgroup><col><col span="7"></colgroup><tbody>
</tbody>

Cells
Return B4
Investment Return C4
Global return D4
Global Investment E4
Total return F4
Decision G4

Last edited:

To be perfectly honest I don't think this makes much sense, but since this is for you, you are the only one it has to make sense to...

Here you go, this seams to be what you asked for:

=IF(B4>=0.1;"Favorable";IF(OR(F4=0.12;AND(C4=0.15;E4>=0.05);AND(F4=0.15;D4<0.1));"Consider";"Do not consider"))

Don't forget to adjust your decimal points and your formula separators to meet your regional settings in case mine are different (as they will probably be 'cause I'm from Portugal)...

Please let us know if it works.

Last edited:

Replies
5
Views
262
Replies
1
Views
487
Replies
1
Views
581
Replies
7
Views
974
Replies
0
Views
595

1,221,412
Messages
6,159,731
Members
451,588
Latest member
tsg178

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back