Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
math applications and formulas
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
math applications and formulas
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. -- Regards, Bill Renaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accounting Applications using Array Formulas | Excel Discussion (Misc queries) | |||
math applications and formulas | Excel Programming | |||
If function and math formulas | Excel Programming | |||
My formulas do not calculate in some Excel applications - help! | Excel Worksheet Functions | |||
Excel Math formulas | Excel Discussion (Misc queries) |