[RESOLVED] When Control Tranfer from One Cell to another Cell :confused:

[pipsmultan]

My very Respectable Greeting to All.

i am facing issue in my Formula of Leave Balance & Half Day Leaves. "Which i think it can be solve by VB Code"

Plz See the Attachment Excel file or Image

http://1drv.ms/1ud0sth



The Formula on cell "G4" is working Good but when it comes on the cell "G5" the FORMULA become out of control

For e.g
Half Day Leaves are subtracting from both Casual & Medical (plz See attach excel file)

When G4 value become Zero then the control transfer to G5 from G4 for further subtraction. BUT G5 taking F4 previous Value which was already been subtracted from the G4 and this thing making the entire result Wrong

I trying to figure it out when control transfer to G5 from G4 for further subtraction, G5 should consider F4 New Entered value as a beginning (ZERO) value NOT (F4 previous Value)

any Help by anyone will be highly obliged thanks

Best Regards

[terry002]

Try this formula in your G5 or H5 for comparison:

=IF((D4-E4-F4) < 0, D5-E5-F5+(D4-E4-F4), D5-E5-F5)

15 - (1 + 16) = -2

G5 = (15 - 5) + (-2)

Medical Remaining = 8

[pipsmultan]

Try this formula in your G5 or H5 for comparison:

=IF((D4-E4-F4) < 0, D5-E5-F5+(D4-E4-F4), D5-E5-F5)

That is amazing...that formula is beyond brilliant. Thanks so much for your help, it is very much appreciated !


Sorry right now i m getting this message "spread some Reputation around before giving it to terry002 again." I will rate your this Kind HELP as soon as i get the chance

My high Regards to you

thanks again alot

[terry002]

That is amazing...that formula is beyond brilliant. Thanks so much for your help, it is very much appreciated !


Sorry right now i m getting this message "spread some Reputation around before giving it to terry002 again." I will rate your this Kind HELP as soon as i get the chance

My high Regards to you

thanks again alot

It's okay @pips. What important is we resolved another inquiry.