math applications and formulas

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

Guest

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
 
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.
 
Back
Top