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