My issue is probably straight forward, but, I cannot tell if the software is at issue or I need a new formula(condition).
I am using an accounting software program called Maestro. It uses Excel formulas in the background when allowing to change a column or row calculation.
In this case, this is the scenario:
The formula I have created:
[PURCHASE AMOUNT]-([PURCHASE AMOUNT]*.10)
EG: 23000 - ( 2300 ) will calculate to 20700 This is okay
but if I put in
a negative value -23000 - (-2300*.10) = (25,300) Adds instead of deduction even with ( ) bracket.
Is there another way of doing this or am I doing it all wrong?
Thank you to all.
Bookmarks