If statement

[ndmalam]

Hi
Please help me to create formula for this situation
there is data in A1 to A30
there is Date in B1 to B30
Now I want to get In C1 to C30

A1 - B1 = C1 ,
and IF
date received in C1 is larger than 20 , it should display 0, other wise display ther result that is equal to A1 - B1 = C1

Best Ragards

[Paul]

Are you trying to say there are dates in column A, dates in column B, and you want to find the difference between A and B? And if that difference is greater than 20, show a 0 in column C, otherwise show the difference?

If so, in C1 put the formula:

=IF(A1-B1>20,0,A1-B1)

and then fill that down as many rows as you need.

If you want to get fancy, try:

=IF(DATEDIF(B1,A1,"D")>20,0,DATEDIF(B1,A1,"D"))

It does the same thing, just a different way.

[ndmalam]

Thanks
these are not dates, just simple figures,
anyway it solve my problem
best regards