math applications and formulas

L

Linda

I need help with following math application:

I have two rows of values. Values in row 2 will change according to the
changes in row 1. The change pattern is: average of those values in row 2
*3+3 when the values in row 1 =0.

I tried the formula: =IF(COUNTIF(A1:Z1,0),AVERAGE(A2:Z2)*3+3,1). It did not
work. Please help.

Thank you,
Linda
 
B

Bill Renaud

Firstly, I think your problem is not well stated.
Secondly, you should probably post this in either the
Microsoft.Public.Excel.Worksheet.Functions or
Microsoft.Public.Excel.Worksheetfunctions newsgroups.
This newsgroup is supposed to be reserved for VBA programming posts.
 

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

If function and math formulas 3
math applications and formulas 2
Development combinations with exclusion of columns 0
Development combinations with exclusion of columns 0
Arrays and scattered cell values or another way? 16
Sort on 3 columns when number of rows vary daily 1
Section and Page numbering 0
Range passed to a function - trying to just move through the range 4

Top