Microsoft Office Forums - View Single Post - nested if and averageA

Thread: nested if and averageA

View Single Post

Old

08-14-2015, 04:13 PM

windseaker windseaker is offline

windseaker is offline

windseaker uses Windows XP

Windows XP windseaker uses Office 2007

windseaker uses Office 2007

Office 2007

Novice

The original poster

Join Date: Feb 2010

Posts: 19

windseaker is on a distinguished road

Default

nested if and averageA

Im trying to figure out an average function for DATA loss in a spreadsheet with a nested if as well. SEE c27

Its a common "reset" issue with meters. I have figured out a simple nested if for any "roll-over" known meter values but not a full unpredicted blank "reset" issue.

Any guidance is welcome.

Ifaverage function

Attached Files

Ifaverage test.xlsx (11.7 KB, 14 views)

Reply With Quote