IF and OR
 

Hi, would somebody be kind enough to explain to me what is incorrect
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 see
whether H11 = GBP or the last 3 characters in cell A11 = FIX, if true
then calculate (G11*I11)/100 otherwise (G11*I11). If ISNUMBER function
is false then show cell as blank.

I hope this makes sense.

Thanks in advance.

Simon


--
sgrech
------------------------------------------------------------------------
sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501
View this thread: http://www.excelforum.com/showthread...hreadid=468945

Hi!

Try

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


Alf


--
AlfD
------------------------------------------------------------------------
AlfD's Profile: http://www.excelforum.com/member.php...fo&userid=4785
View this thread: http://www.excelforum.com/showthread...hreadid=468945

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

Cheers
Simon


--
sgrech
------------------------------------------------------------------------
sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501
View this thread: http://www.excelforum.com/showthread...hreadid=468945

You didn't test for FIX

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

--
HTH

Bob Phillips

"sgrech" wrote in
message ...

Hi, would somebody be kind enough to explain to me what is incorrect
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 see
whether H11 = GBP or the last 3 characters in cell A11 = FIX, if true
then calculate (G11*I11)/100 otherwise (G11*I11). If ISNUMBER function
is false then show cell as blank.

I hope this makes sense.

Thanks in advance.

Simon


--
sgrech
------------------------------------------------------------------------
sgrech's Profile:
http://www.excelforum.com/member.php...o&userid=14501
View this thread: http://www.excelforum.com/showthread...hreadid=468945

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

"sgrech" wrote in
message ...

Hi, would somebody be kind enough to explain to me what is incorrect
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 see
whether H11 = GBP or the last 3 characters in cell A11 = FIX, if true
then calculate (G11*I11)/100 otherwise (G11*I11). If ISNUMBER function
is false then show cell as blank.

I hope this makes sense.

Thanks in advance.

Simon


--
sgrech
------------------------------------------------------------------------
sgrech's Profile:
http://www.excelforum.com/member.php...o&userid=14501
View this thread: http://www.excelforum.com/showthread...hreadid=468945