thanks for your help. the formulae worked with a slight change, i removed =TRUE because it was giving me some message and also *100 because I already had the cell formated to percentage.
now its changing to "-" many thanks for your help
Last edited by accablues; 07-26-2011 at 10:32 PM.
|