Dear All,
Good day/night.
I have a tabulate consisting of the following inputs:
Beg. Value(A1)
Purchases(B1)
Sales(C1)
End. Value(D1)
Formula(E1)=If(....
I'd like to create a formula to be able to divide the (Ending value/Beg. value) -1, but with slight adjustment. I'll explain:
Sometimes there's 0 value under one or two of the first three captions (Beg. Value, Purchases, or Sales) and i want my formula to capture that. Hope that's clear.
Many thanks,
Marwan
Good day/night.
I have a tabulate consisting of the following inputs:
Beg. Value(A1)
Purchases(B1)
Sales(C1)
End. Value(D1)
Formula(E1)=If(....
I'd like to create a formula to be able to divide the (Ending value/Beg. value) -1, but with slight adjustment. I'll explain:
Sometimes there's 0 value under one or two of the first three captions (Beg. Value, Purchases, or Sales) and i want my formula to capture that. Hope that's clear.
Many thanks,
Marwan
Last edited: