Forum Discussion
Excell Discount Formula
I don't know exactly what you intend to do, since no exact dates have been given, but the formula should look like this.
=IF(B36="FUL",(R36/1.4),(R36*1))
With your permission, next time I suggest you provide more information.
You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.
What I recommend: Always inform your plans about the Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.). If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.
In this link you will find some more information about it:
Welcome to your Excel discussion space!
Thank you for your understanding and patience
Hope I was able to help you with this info.
I know I don't know anything (Socrates)