performing algorithm

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(AND(ISNUMBER(A1),A1=0),A2*2,1))
 

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

VBA Linest function for polynomial regression on horizontal range 0
Vlookup help please 2
conditional format fails when copied 1
Excel formula, sum the value cell and if empty cell left blank 0
If function with average fomula to be tru or false 1
Get rid of need for F2.Select 3
Conditional Formatting macro: simple, but doesn't work 6
VBA code for 5-rule Conditional Formating 10

Back
Top