Hello,
i wanna try to create query where I want to subtract the value of C from the two fields, A and B.
Basically A-C and B-C.
But that the subtraction from the column A goes to result 0. When the final result is zero the subtraction from B the column begins.
I was try until now to use conditional formating.
In same time i substract c from both column, and if resul > 0 display, result, if = 0 i says display "0" for fisrt column
For second i add A+B like F. Until F>B display. B starting value. Its not good.
Is it posible and on which way do something like this:
i wanna try to create query where I want to subtract the value of C from the two fields, A and B.
Basically A-C and B-C.
But that the subtraction from the column A goes to result 0. When the final result is zero the subtraction from B the column begins.
I was try until now to use conditional formating.
In same time i substract c from both column, and if resul > 0 display, result, if = 0 i says display "0" for fisrt column
For second i add A+B like F. Until F>B display. B starting value. Its not good.
Is it posible and on which way do something like this:
Code:
If A>0 then
A-C = result
else
B-C = result
.....