IF Statements

  • Thread starter Thread starter DoubleJ0601
  • Start date Start date
D

DoubleJ0601

I want to add an IF staement to my worksheet that states if Cell A3 i
equal to or less than 0, then cells A4 to A8 also equal 0. Is thi
possible. Also, if I can add a counter to a cell to add 1 every tim
A3 =0. But that is not as important as the first part
 
What you want to do is paste this formula into cells A4 thru A8

=IF(A3<=0,0,"")

As far as the counter is concerned, I don't know exactly what you're looking
for. A3 can only equal 0 once in a sheet. Please elaborate.
 
Back
Top