chedd wrote:
Hi

[quoted text clipped - 5 lines]
cells B and C register above 0 each i.e 1 and 1 i am getting 100% with cell
E reading high instead of Equal.

Thank you it worked atreat. However where there is a minus in cell c(-17)
t this shows in cell D as -65% giving a default in cell E #Ref!. Is there
any way in the formula in cell E to recognise the minus fig to show lower.

Sorry about this, but your help has been most valulable.

Sorry about this, but have checked and there are no errors. The problem
appears to be when there is a minus sign (-17 in cell C and -68%) is causing
the error message. All other cells which do not show a minus are okay.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200606/1