Dear All Experts excel
me as a beginner, on this forum
please help me to get started on the attached excel attechmen
thanks
Greetings, Ira
Edit
How to check for negative or equal values from IF statements?
Dear All Experts excel
me as a beginner, on this forum
please help me to get started on the attached excel attechmen
thanks
Greetings, Ira
How to check for negative or equal values from IF statements?
In your attached file, I don't understand the third issue, ask another question for that one but make sure to describe the issue in the question itself along with attaching the sample file.
To return blanks for negative values or the postiive value itself use a formula like this:
=IF(A1<0,"",A1)
This works for cell A1, change the references to work for your data.
The second issue you had, you were at least on the right track kind of:
=IF(AND(A1=A2,A2=A3),A1,"")
This makes sure that A1, A2, and A3 are the same and it outputs the value from A1 if that's true.
Thanks ,two formula. i wait the second conditional formatting formula for top / batom