Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
An Advance IF | Excel Worksheet Functions | |||
I need a little help...thanks in advance | Excel Discussion (Misc queries) | |||
Here's one for you...(thanks for the help in advance) | Excel Discussion (Misc queries) | |||
Advance if statements? | Excel Programming | |||
Help Please! Thanks in advance. | Excel Programming |