I have inherited a lot of files that have interesting formulas in them and I now need to revise a few things.
In the attached document, you will see starting at I5 that there are sales value typed in. If the sale is cancelled, I want to be able to manually add a (-) negative sign to the amount in I5 and have Excel add the same to the other columns in that row.
Can it be done:
Thanks for your help!
Remove Sale Sample.xlsx
How do we understand if a particular sale is cancelled? In which column is it indicated in the worksheet? If there is one such column, then an IF condition can be written as
Say, col R contains such details, then in another adjacent column use,Formula:
Please Login or Register to view this content.
Last edited by Saarang84; 07-16-2014 at 01:42 PM.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
That is certainly an option, but it didn't work.
I wanted the actual sale (I5) to become a negative.
I put a cancelled column with a x, replaced the cancelled text in the formula with x and it returns a positive 1000 in the cell the formula is in; not I5 with a negative as we hoped!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks