Help Me

[trese262000]

Can anyone tell me how to write an exception to
formula............................PLEAS

 

[JE McGimpsey]

Not unless you tell us what your idea of an "exception to a formula"
is...

 

[David McRitchie]

Very little to go on, I guess we can make up our own
question to answer.

Take a look at the IF Worksheet Function in HELP
F1 --> Index --> IF Worksheet Function

=IF(A1="Good", "yes", "no")

 

[Norman Harker]

Hi trese262000

You don't get more help posting the same question more than once!

Here's very limited help posted before for a question with limited
information:

One way, with very little to go on:

=IF(AND(A1<100,NOT(A1=50)),"<100, <> 50")

We don't tend to use NOT much as there are usually other ways to
handle it.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.