Stop displaying a message because of a formula

U

Urgent Help

I have a formula very simple in 2000 columns.

A B C
1 5 3 =IF(B3-A5=0, "ORDER COMPLETE")

It works pretty nice, but i have the formula copied in 2000 columns. Even if
i don't write down any data, the column C is giving me the message because i
haven't entered information for A and B, so C recognices a zero as a result.
As a consequence, the phrase ORDER COMPLETE, shows in the rest of the 2000
columns. How can i get that message only when it is 0 zero by entering data
only to A and B
 
T

T. Valko

One way:

=IF(COUNT(A1:B1)<2,"",IF(A1=B1,"Order Complete",""))

Copied down as needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Urgent help with Excel formula. Please please help 1
Formula than understands midnight? 26
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
series of formulas to get to one formula 0
Index / Match Formula Problem 4
Formula for calculating target hours against actual hours 12
Copy pair of columns 3
Function or Sub to help with text string 5

Top