excel formula assignment

[kanee_2010]

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

[FDibbins]

Hi, welcome to the forum

Is this a homework assignment?

[kanee_2010]

Unfortunately yes
Can you please help me? I have been looking for a solution for hours.

[FDibbins]

I appreciate your honesty

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.