T
trese262000
Can someone please help me. I need to know how to write and exception
in a formula.....PLEASE, PLEASE, PLEASE
in a formula.....PLEASE, PLEASE, PLEASE
K
Ken Wright
OK, but a tad more information wouldn't go amiss 
What's the formula you have, and whats the exception you want to cater for?
What's the formula you have, and whats the exception you want to cater for?
N
Norman Harker
Hi trese262000
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.
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.