Altering an IF Formula.

[Excel_77]

Hi,

I need some help with the formula below:

Basically in order to get a true value, if J has a GBP or EUR then column R must have value under 40 and in addition to this, column O must have a value that is less than 33% of the value in column R.

The second part is that if column J has anything in it other than GBP or EUR then it must check column S and return "True" only if the value here is less than 67 and the subsequent value in column P is less than 33% of the value in column S.

The formula below doesn't quite work and any help would be great.

=IF(AND(O13 <=R13/0.332,R13 < IF(OR(J13="GBP",J13="EUR"),40,67)),"True","")

Thanks

 

[PlusX EAI]

=IF(OR(J4="GBP";J4="EUR");IF(AND(R4<40;O4<R4/3);"True";"");IF(AND(S4<40;P4<S4/3);"True";""))

 

[Excel_77]

=IF(OR(J4="GBP";J4="EUR");IF(AND(R4<40;O4<r4 color="#333333" 3);<font="">"True";"");IF(AND(S4<40;P4<s4 color="#333333" 3);<font="">"True";""))

Thanks but that code is returning an error message?

</s4></r4>

 

[PlusX EAI]

There is a problem with the editor here:

O4<r4 3;"true";"")
smaller sign R4/3;"True";"")

and

P4<r4 3;"true";"")
smaller sign S4/3;"True";"")</r4><s4 3;"true";"")<="" html=""></s4></r4>

 

[Excel_77]

ADVERTISEMENT

There is a problem with the editor here:

O4<r4 3;?true?;??)
smaller sign R4/3;"True";"")

and

P4<r4 3;?true?;??)
smaller sign S4/3;"True";"")</r4><s4 html="" 3;?true?;??)<=""></s4></r4>

Can you paste the entire code again? Still getting errors.

 

[PlusX EAI]

=IF(OR(J4="GBP";J4="EUR");IF(AND(R4%40;O4%R4/3;<r4 color="#333333" 3);<font="" style="color: rgb(51, 51, 51); font-style: italic; background-color: rgb(242, 246, 248);">"True";"");IF(AND(S4%40;P4%S4/3;<s4 color="#333333" 3);<font="">"True";""))

replace percentage sign with smaller sign</s4></r4>

 

[Excel_77]

ADVERTISEMENT

=IF(OR(J4="GBP";J4="EUR");IF(AND(R4%40;O4%R4/3;<r4 style="color: rgb(51, 51, 51); font-style: italic; background-color: rgb(242, 246, 248);" color="#333333" 3);<font="">"True";"");IF(AND(S4%40;P4%S4/3;<s4 color="#333333" 3);<font="">"True";""))

replace percentage sign with smaller sign</s4></r4>

Still not working unfortunately.

 

[PlusX EAI]

My system uses ;

Yours looks like using ,

Try to replace ; with ,

 

[Excel_77]

My system uses ;

Yours looks like using ,

Try to replace ; with ,

Using the below but it is not being accepted:

=IF(OR(J4="GBP",J4="EUR"),IF(AND(R4<40,O4<R4/3,"True",""),IF(AND(S4<40,P4<S4/3,"True",""))

 

[Excel_77]

<r4 html="" 3,?True?,??),IF(AND(S4<40,P4<S4="" 3,?True?,??))<="" 3,?True?,??))<r4="">=IF(OR(J4="GBP",J4="EUR"),IF(AND(R4<40,O4

It won't allow me to paste the full code, why is this so difficult?</r4>