IF and OR

[sgrech]

Hi, would somebody be kind enough to explain to me what is incorrec
with the following forumula.

=IF(ISNUMBER(I11),IF(OR(H11="gbp",(RIGHT(A11,3)),(G11*I11)/100,(G11*I11)),""))

Is the value in I11 is a number. If this is true then check to se
whether H11 = GBP or the last 3 characters in cell A11 = FIX, if tru
then calculate (G11*I11)/100 otherwise (G11*I11). If ISNUMBER functio
is false then show cell as blank.

I hope this makes sense.

Thanks in advance.

Simo

 

[AlfD]

Hi!

Try

=IF(NOT(ISNUMBER(I11)),"",IF(OR(H11="gbp",RIGHT(A11,3)="FIX"),G11*I11/100,G11*I11))


Al

 

[sgrech]

Thanks for you help but I have resolved the problem myself, seems like I
got some of the brackets wrong.

Cheers
Simon

 

[Bob Phillips]

You didn't test for FIX

=IF(ISNUMBER(I11),IF(OR(H11="gbp",RIGHT(A11,3)="FIX"),(G11*I11)/100,(G11*I11
)),"")

 

[Anne Troy]

=IF(ISNUMBER(I11),IF(OR(H11="gbp",RIGHT(A11,3)="fix"),(G11*I11)/100,G11*I11),"")
************
Anne Troy
www.OfficeArticles.com