One way in C6 dragged across and down
Formula:
=IF((9-ROW($C9))-(3-COLUMN(C$9))>=0,ROUND($B6-($B6*MAX(0,COLUMN(C6)*2-5-(ROW(C6)-6)*2)/24),0),"")
One way in C6 dragged across and down
Formula:
=IF((9-ROW($C9))-(3-COLUMN(C$9))>=0,ROUND($B6-($B6*MAX(0,COLUMN(C6)*2-5-(ROW(C6)-6)*2)/24),0),"")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks