| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop displaying a message because of a formula
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stop displaying a message because of a formula
One way:
=IF(COUNT(A1:B1)<2,"",IF(A1=B1,"Order Complete","")) Copied down as needed. -- Biff Microsoft Excel MVP "Urgent Help" <Urgent wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Stop displaying a message because of a formula
Try
=IF(AND(COUNT(B3,A5)=2,B3-A5=0),"Order Complete","") Mike "Urgent Help" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i stop formulas from displaying like this =R[-49]C+R[-25] | Excel Worksheet Functions | |||
| Why use comma instead of full stop for displaying value? | Excel Discussion (Misc queries) | |||
| How can I stop Excel from displaying alerts? | Charts and Charting in Excel | |||
| Displaying an error message if entries exceed 100% | Excel Discussion (Misc queries) | |||
| Reviewing Toolbar - how to stop it from displaying | Excel Worksheet Functions | |||
Linear Mode
