Hi
What happens when A1 =1 ??
I have allowed for this in the formula below by having A1 <= to 1
Put this in B1
=IF(A11,A1-1,IF(A1<=1,0,""))
HTH
Michael
"sabretooth54" wrote:
trying to create this formula: if a1 is greater than 1 then b1 will equal a1
minus 1 and if a1 equals less than 1 then b1 will equal zero.
|