Try this out, let me know if it works:
= IF(INDIRECT("Weighted Average!"&"M"&3*(ROW()-2)) = "",A1+B1,IF( INDIRECT("Weighted Average!"&"M"&3*(ROW()-2))>0.001,INDIRECT("Weighted Average!"&"M"&3*(ROW()-2))))
Try this out, let me know if it works:
= IF(INDIRECT("Weighted Average!"&"M"&3*(ROW()-2)) = "",A1+B1,IF( INDIRECT("Weighted Average!"&"M"&3*(ROW()-2))>0.001,INDIRECT("Weighted Average!"&"M"&3*(ROW()-2))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks