Advance if statements?
 

The message below refers: I am trying to create some kind of artificial
intelligence where I compare data sets, e.g. R13:W13 is a part of a
structure, Z13:AE13 is another part. What I need the inferencing machine to
do is to say if R13:W13 have values between 1 and 4 and Z13:AE13 have values
between 1 and 3, structure is Ok
=IF(COUNTIF(R13:W13,"<4",Countif(Z13:AE13,"<3","OK ","Replace")))

I actually want to produce one ling if statement where each scenario has a
set output. Please help

Advance if statements?
 

Hi Ralph

the structure of an IF(AND()) function is
=IF(AND(condition1,condition2,....,condition29),tr ue,false)

i think you should be able to achieve what you want using this structure

Hope this helps
Cheers
JulieD


"Ralph" wrote in message
...
The message below refers: I am trying to create some kind of artificial
intelligence where I compare data sets, e.g. R13:W13 is a part of a
structure, Z13:AE13 is another part. What I need the inferencing machine
to
do is to say if R13:W13 have values between 1 and 4 and Z13:AE13 have
values
between 1 and 3, structure is Ok
=IF(COUNTIF(R13:W13,"<4",Countif(Z13:AE13,"<3","OK ","Replace")))

I actually want to produce one ling if statement where each scenario has a
set output. Please help

Advance if statements?
 

=If(And((countif(R13:W13,"=1")-countif(R13:W13,"4"))=6,(countif(Z13:AE13,"
=1")-countif(Z13:AE13,"3"))=6),"OK","REPLACE")

--
Regards,
Tom Ogilvy

"Ralph" wrote in message
...
The message below refers: I am trying to create some kind of artificial
intelligence where I compare data sets, e.g. R13:W13 is a part of a
structure, Z13:AE13 is another part. What I need the inferencing machine
to
do is to say if R13:W13 have values between 1 and 4 and Z13:AE13 have
values
between 1 and 3, structure is Ok
=IF(COUNTIF(R13:W13,"<4",Countif(Z13:AE13,"<3","OK ","Replace")))

I actually want to produce one ling if statement where each scenario has a
set output. Please help