Forum Discussion
Formula/VBA Help
sherikhan88 Glad it worked. The part of the formula you refer to is just to "reset the calculation in column F when the product code in column A changes AND there's nothing more to be fulfilled. The N() function allows you to reference text fields in calculations. Entering E2-E1 would result in an error as E1 contains a text, i.e. the column header. Wrapping E1 in N( ) returns zero in this case. Alternatively, you could use SUM(E2,-E1) as sum ignores texts. whatever you prefer.
To understand what --(A2=A1) does, just enter it in an empty cell on row 2, with an= sign in front, of course, and drag it down.
sherikhan88 Perhaps like in the attached file. Not sure about how you got to the answers that I marked in yellow.
- Sir, you are became my ideal. Amazing, wonderful, excellent. Thank you so much for your help, that is exactly how I want to see the numbers.
If you dont mind could you please enlighten me that what is below mentioned function is doing in fulfilment formula.
E2-N(E1)*--(A2=A1)sherikhan88 Glad it worked. The part of the formula you refer to is just to "reset the calculation in column F when the product code in column A changes AND there's nothing more to be fulfilled. The N() function allows you to reference text fields in calculations. Entering E2-E1 would result in an error as E1 contains a text, i.e. the column header. Wrapping E1 in N( ) returns zero in this case. Alternatively, you could use SUM(E2,-E1) as sum ignores texts. whatever you prefer.
To understand what --(A2=A1) does, just enter it in an empty cell on row 2, with an= sign in front, of course, and drag it down.
- Understood, Thank you so much Sir. Appreciate your help in this important task for me.
Respect..
- any yes, I made a mistake in those highlighted numbers.
