View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LINDA LINDA is offline
external usenet poster
 
Posts: 205
Default 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