Hello there,
I'm writing about the workbook attached. Basically this what it consists on, there are 3 columns:
- Column A & C: random numbers, either integers or decimals
- Column B: ADD/SUBTRACT
Therefore, I would need to get the result of the calculation in Column D, depending on whether Column B is set as "ADD" or "SUBTRACT". Is there a way to do this?
Thanks a lot in advance for your help!
how about
=IF(B2="ADD",A2+C2,IF(B2="Subtract",A2-C2,""))
copy down
was not sure which way the subtraction should occur - A-C or C-A - so just change around to match your requirement
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Try:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks