LinkBack URL
About LinkBacks
In L24 then drag across
In F8then drag across
=IF(MOD(COLUMNS($L24:L24),INDEX($G$11:$G$13,MATCH($J24,$D$11:$D$13,0)))=0,$K24*OFFSET($E$8,0,COLUMNS($J$24:J24)-1),K24)
Pl see changesin E8:I8 and K24:K26=E8*(1+F7)
In L24 then drag across
In F8then drag across=IF(MOD(COLUMNS($L24:L24),INDEX($G$11:$G$13,MATCH($J24,$D$11:$D$13,0)))=0,$K24*OFFSET($E$8,0,COLUMNS($J$24:J24)-1),K24)
Pl see changesin E8:I8 and K24:K26=E8*(1+F7)
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks