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