Conditional Formulas and finding lower numbers in a series
Thanks for your post..
I have for example a set of cells:
A1=12
B1=5
C1=4
D1=3
E1=7
F1=20
G1=9
and I want to have a cell read "eureka" if three values are <6 for example.
an (AND(OR)) can be used I am sure, just don't know how.
"Roger Govier" wrote:
Hi
Try
=IF(AND(A1<100,B1<50,C1<30),"Eureka!","")
--
Regards
Roger Govier
"chrysler265" wrote in message
...
I am trying to create a conditional formula which can show a keyword in
a
cell - if the values in a set of cells has three values under 'x'
amount.
Is this possible??
|