Help Me

  • Thread starter Thread starter trese262000
  • Start date Start date
T

trese262000

Can anyone tell me how to write an exception to
formula............................PLEAS
 
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")
 
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.
 
Back
Top