Better way to do this

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best way to do this!! 0
Best way to do this!! 0
Is there a better way to do this? 6
Word Error Message: This file is corrupt and cannot be opened 1
Dont know if this is possible to do 0
Macro to shift to next row 2
STUDENT IF statement & incrementing 0
how do I loop this macro? 2

Top