# Altering an IF Formula.

#### Excel_77

##### Active Member
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

### Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
=IF(OR(J4="GBP";J4="EUR");IF(AND(R4<40;O4<R4/3);"True";"");IF(AND(S4<40;P4<S4/3);"True";""))

=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>

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>

Last edited:
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.

=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>

=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.

My system uses ;

Yours looks like using ,

Try to replace ; with ,

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",""))

Last edited:
<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>

Last edited:

Replies
8
Views
157
Replies
3
Views
66
Replies
0
Views
83
Replies
21
Views
529
Replies
1
Views
165

1,196,515
Messages
6,015,661
Members
441,914
Latest member
VBAllTheThings

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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