Calculate average in a cell from one of two columns

B

BillO

Hi

How can I calcualte an average in one cell from two different columns of
data depending on which is populated. Oh yea one column has a function
applied to it and if there is no data it returns a zero...I only want the
average if the data exists.

%T OD Convert OD to %T Test for blanks
10.00 1.00 =(10^-C19)*100 =IF()

1.00 10.00 10
1.00 10.00 10
5.00 0.00 0.001
2.00 1.00 1
0.50 31.62 31.6227766
100.00 100
100.00 100

See problem is when no data exists the log function takes "0" and turns it
into 100.

thanks
 
B

Barb Reinhardt

=if(isblank(A19)=FALSE,(10^-C19)*100,NA())

I'm not sure if it's A or B from what you have.

Let's say you want to take the average of c1 -C10 but you only want to do it
if A1:A10 is not blank.

Try this:
=AVERAGE(IF(ISBLANK(A1:A10)=FALSE,C1:C10))

Commit with CTRL SHIFT ENTER (formula should have {} around it if done.
 

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

Top