help please

[formratings]

SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED
this formula is in a sheet called ignore
=IF(AVERAGE(dataformlatest!BA4,dataformlatest!BK4)<0,0,AVERAGE(dataformlatest!BA4,dataformlatest!BK4,))
and runs down a full column,BA4,BA5,BA6 which has a different value in each etc how do I add the value of another
ignore column BS4,BS5,BS6 etc to it which has different values in it
many thanks

 

[tyija1995]

Hey,

So would you want to return 0 for the average if AVERAGE(BA4,BS4,BK4) < 0 ? otherwise return their average? is that right?

If so then the formula would be:

=IF(AVERAGE(dataformlatest!BA4,dataformlatest!BK4,dataformlatest!BS4)<0,0,AVERAGE(dataformlatest!BA4,dataformlatest!BK4,dataformlatest!BS4))

 

[Fluff]

Another option
=MAX(0,AVERAGE(dataformlatest!BA4,dataformlatest!BK4,dataformlatest!BS4))

 

[formratings]

thank you

 

[formratings]

Hi sorry I wanted it to be plus BS4%

 

[formratings]

return the average of BA and BK and if 0 for either doesn't count and then plus BS %
so average in this case is 20.7 plus BS% which is 11% = 22.97

 

[Fluff]

Maybe
=MAX(0,AVERAGE(dataformlatest!BA4,dataformlatest!BK4)*(1+,dataformlatest!BS4))

 

[formratings]

thanks Fluff but it didn't work

 

[Fluff]

In what way?
Saying "It didn't work" is not very helpful

Can you please post some sample data using the XL2BB add-in?

 

[formratings]

sorry don't know what XL2BB is this is what I get