I want to set up an alert to warn the user the Cost of Sales they entered is too high. They will be able to input Cost in Column A and Retail Price in Column B while Column C automatically calculates the COS %.
I would like to have an alert pop up when a COS % is outside of a particular range (ie 35% - 55%). Unfortunatley, Ive had a tough time figuring out how to enter a % range in Data Validation. I have tried just using decimals but with no sucess.
Any help?
Thanks!
I would like to have an alert pop up when a COS % is outside of a particular range (ie 35% - 55%). Unfortunatley, Ive had a tough time figuring out how to enter a % range in Data Validation. I have tried just using decimals but with no sucess.
Any help?
Thanks!