Problem with if function

[Roger Albrecht]

Dear all,

I have a problem with "IF" function. 

There is no problem if I use a cell where I just add numbers manually.

But if I use a cell where there are a formula, then I do not get my "IF" function to work.

Please se attached example.

Hoping for your kindness help,

Roger

[#2]

=IF($A$20>0,"Jan","")
the above cell reference is an absolute reference (with $ sign) meaning it is fixed at that location. Therefore in cell B33 the formula should be =IF($A$33>0,"Jan","") and so on..

ALSO =IF(COUNT($A$7:A7)>$F$4,"0",A7+1)  

change to =IF(COUNT($A$7:A7)>$F$4,0,A7+1)

no quotation marks on zero
if this is a template - you could manually change all cell formula..

[#3 · Accepted solution]

pls find attached file..

[#4]

Thank you for your valuable help.

[#5]

glad to help..