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