Hello everybody,
Can you please help me to find a suitable VBA code or formula so I can resolve this assignment
I have the following data
G44: $356
G45: $0
G46: $0
G47: $0
G48: $0
G49: $0
G50: $0
G51: $356
G52: -$217
G53: $138
I want to find G47, but this is my constraint:
if G52 is negative then 0 then look for G44 and see if it is negative then 0
G52 should always be less or equal to 0
if G52 and G44 are positive do a difference between the two and put it negative in G47
Thank you for your help
it is a bit complicated
Bookmarks