Hi

Using Excel - In column A I can enter 4 different cash values e.g. 30 / 13
/ 10 / 5

using the formula in column B/C/D/E =IF(A3=Rate_30,A3,"") 30 shows in the
cell B3 cells C3 / D3/ E3 for that row shows zero

However when I need another rate e.g. 50 to enter column F and changing the
above formula to =IF(A3=Rate_50,A3,"") the cell shows #NAME? - what am I
doing wrong ????

Any much appreciated

Cheers --- Mully