Multiple If fuction help needed

[TheBradster]

I've been sitting with this for a week, and have gotten nowhere. Please help me.

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

 

[steve the fish]

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”

 

[Andrew Poulsom]

Welcome to MrExcel.

Please post some sample data and the expected results.

 

[Special-K99]

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

 

[TheBradster]

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

 

[ricardomadaleno]

Hi TheBradster,

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.