Hi all
I'm an IT student working on a data modelling assignment with a scenario that has to do with sales and profit margins.
This is what I would like to achieve:
I currently have a table showing the item cost, sale price and profit. My profit margin is separate and when the value is changed it changes only the profit (I don't want it to change the sale price as well). I would like the set up some sort of validation or conditional formatting to ensure that the sale price is always equal to cost plus profit.
For example (not correct syntax):
cost price (A1) sales price (A2) profit (A3)
A2=A1+A3 (true)
If the statement is not true I would like a message to pop up in another cell (not a pop up box) stating that the user needs to change the profit margin in order to make it true.
What is the best way to go about doing this sort of thing?
I hope this makes sense