V
v4mpy
I need help, Formula in L4 is fine as below. I'm trying to get L6, so
after W
is inserted into I6 instead of adding up H4-H6 it starts adding up at
H7 down
until next W is inserted, then start process again.
I would like a formula that doesn't matter where L or W are: it justs
starts
adding from the last W for column I.
=IF(ISERROR(IF(I4="W",-H4,H4*E4/G4)),"-",IF(I4="L",-H4,H4*E4/G4))
B E G H I J K L
4 2.5 6 4 2.50 L 5 7.5 -2.5
5 7.5 5 2 3.75 L 11.25 13.75 -6.25
6 13.75 6 2 5 W - - 8.75
7 2.5 7 2 1.25 L 3.75 6.25 -1.25
I hope this all makes sence.
Thanks
after W
is inserted into I6 instead of adding up H4-H6 it starts adding up at
H7 down
until next W is inserted, then start process again.
I would like a formula that doesn't matter where L or W are: it justs
starts
adding from the last W for column I.
=IF(ISERROR(IF(I4="W",-H4,H4*E4/G4)),"-",IF(I4="L",-H4,H4*E4/G4))
B E G H I J K L
4 2.5 6 4 2.50 L 5 7.5 -2.5
5 7.5 5 2 3.75 L 11.25 13.75 -6.25
6 13.75 6 2 5 W - - 8.75
7 2.5 7 2 1.25 L 3.75 6.25 -1.25
I hope this all makes sence.
Thanks