Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

IF statement help - checking for negative values and equal values

0

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?

Post Edited
Title: Title was not descriptive.
Answer
Discuss

Discussion

Dude, please don't post the same question 3 times. I delete 2 of them for you. If you need to adjust a question, just click the Edit link under it and you can add information or attach files. 

Also, you need to ask a specific question on here if you want help. For instance, for this question, you should ask something like "How do I write a formula that returns blanks for negative numbers, but outputs the positive numbers?"

You get a pass this time, but please don't do this for future questions.
don (rep: 1989) Jun 28, '18 at 10:18 am
Add to Discussion

Answers

0
Selected Answer

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.

Discuss
0

Thanks ,two formula. i wait the second conditional formatting formula for top / batom 

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login