Can Excel perform algorithm? I have a set of rules for computaton of my data
as follows. I wonder if I could use Excel to do it.

Rule 1: =IF(A1=0,A2*2,1)
Rule 2: =IF(A1:F1=0,A2)

Please help.

Thank you,
Linda

If rule 1 is true, then Rule 2 would not be checked. I will assume you want
to check rule2 first
=IF(AND(COUNT(A1:F1)=6,COUNTIF(A1:F1,0)=6),A2,IF(A ND(ISNUMBER(A1),A1=0),A2*2,1))

--
Regards,
Tom Ogilvy


"Linda" wrote:

Can Excel perform algorithm? I have a set of rules for computaton of my data
as follows. I wonder if I could use Excel to do it.

Rule 1: =IF(A1=0,A2*2,1)
Rule 2: =IF(A1:F1=0,A2)

Please help.

Thank you,
Linda