Advance if statements?

G

Guest

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
 
J

JulieD

Hi Ralph

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

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

Hope this helps
Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 If/Then statements in 1 sub not working correctly 2
Finding the weighted average of text that have been given values 1
unique key in an excel 2007 table 5
Using variable in Excel formula in VBA statement 3
Delete Rows with Conditions 1
COUNTIF Multiple Values 3
Run a macro from an If statement 1
VBA code outputs currency value rounded to 2 decimal points 7

Top