Need Help Please

  • 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 time A
=0. But that is not as important as the first part
 
Hi Double!

Try this in cell A4 and drag copy over to A8:

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

You didn't say what you wanted to do if A3>0. You can
replace "Undefined" with whatever you like. If it's a text
string, just enclose it within "quotes". If you want a
blank cell, use "".

For your counter:

http://www.mcgimpsey.com/excel/accumulator.html

Biff
 
Back
Top