Help writing a macro

A

alldreams

HI everyone,

I have very little experience with VBA. Could you help
me get this conditions in an excel macro since I can't
figure out how to use them in a formula?

1.) DAY 1
IF A3 < A5 AND A4 > A5,
THEN A6 = A4 - A5 AND A7 = LONG.

IF A3 < A5 and A4 < A5
THEN A6 = A4 - A5 AND A7 = LOSS

IF A3 > A5 AND A4 < A5 THEN A7 = NOT LONG

2.) DAY 2
IF A7 = LOSS OR NOT LONG
THEN 1.) for next column B

IF A7 = LONG
THEN IF B4 > B5,
THEN B6 = B4-A5 AND A6 = 0 AND B7 = LONG.
IF B4 < B5 THEN B6 = B4-A5 AND A6 = 0 AND B7 = CLOSE
LONG.



This loops until the last nonblank value in row 1.

Thanks in advance.
 
Top