Hi chaps I'm not very good at Excel for which I apologise! I am trying to populate a cell with the results of a sum in another cell. What I have is a kind of grid, if the value in cell A1 is 0 then that value must appear in cell D6. If the value in cell A1 is between 1 and 3 then that value must appear in cell D7 Does that make sense?! Any help would be really appreciated. Many thanks lynne

You need two if formula's. In cell D6 put the following: =IF(A1 = 0,A1,"") This means if A1 is = 0 then put the contents of AI into this cell, otherwise make it blank. In Cell D& put the following: =IF(A1 > 0,IF(A1 < 4,A1,""),"") This means that if A1 > 0 then do the second If which is < 4. If both > 0 and less than for are true then put the contents of A1 into the cell, otherwise make it blank. If A1 = ) then the second If statement doesn't get executed and "" is entered into the cell Stuart

or: =IF(AND(A1 < 4, A1 > 0),A1,"")

G'day, Try this: D6=IF(A1=0,A1,"") D7=IF(AND(A1>=1,A1<=3),A1,"") regards, Elric