I need a formula in C1 that does the following: New Question

March 8, 2012 at 10:08:51
Specs: Windows XP
I got the formula for: if A1>=0 and B1 <=0 then set C1 to "Not Good".
Instead of not good, I want it to search A1 and B1 for the highest value and if the highest value is in A1 then put that value in C1, if the highest value is in B1 set C1 to 0

IF(AND(A1>=0,B1<=0),_______________________________

Thanks


See More: I need a formula in C1 that does the following: New Question

Report •

#1
March 8, 2012 at 11:17:13
Once again, I have to ask:

What happens if A1 and B1 both equal zero?

Since there will be no "highest value" in that case, what do you want in C1?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 8, 2012 at 13:48:58
if it equals 0 then set C1 to "Not Good"

Report •

#3
March 8, 2012 at 17:35:17
If it equals zero?

Which it? Your question involves 2 cells A1 and B1, so saying it is not clear enough for us.

You need to learn to ask your questions more clearly. Since there is a major difference between IF(A1>0,... and IF(A1>=0,... you need to be specific or we're apt to offer a solution that won't fit your needs.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
March 9, 2012 at 01:56:59
If A1 and B1 = 0 then set C1 to "Not Good"

Report •

#5
March 9, 2012 at 06:16:07
What happens if A1 and B1 equal each other, but they don't equal 0?

e.g. the condition where A1 = 1 and B1 = 1 is not covered in your reqiurements.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
March 9, 2012 at 09:55:51
if A1 and B1 = 1 is it possible to set C1 to "Not Good"

Report •

#7
March 9, 2012 at 10:15:20

Report •

#8
March 10, 2012 at 00:02:29
Thanks, I really appreciate you helping me. How about the first part of the question,
where I want a search done on A1 and B1 for the highest value and if the highest value is in A1 then put that value in C1, if the highest value is in B1 set C1 to 0.

Thanks


Report •

#9
March 10, 2012 at 01:04:59
Did you test my latest suggestion?

As far as I can tell you have asked for a formula to deal with 3 conditions:

If A1 is greater than B1, C1 = A1
If B1 is greater than A1, C1 = 0
If A1 equal B1, C1 = Not Good

My lastest suggestion handles all 3 of those conditions.

=IF(A1=B1, "Not Good", IF(A1>B1, A1, 0))

May I suggest that you spend some time reading the Excel Help files on the IF function. Google can also provide a lot of help and examples on all Excel functions.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#10
March 12, 2012 at 20:12:03
Thank you very much. You were right. The answer that you provided was correct. I was trying to use the MAX function to solve the problem.

Report •

#11
March 12, 2012 at 20:45:20
Well, there's no need to use the MAX function, but you could...

=IF(A1=B1, "Not Good", IF(MAX(A1:B1)=A1, A1, 0))


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question