OrderTester1
New Member
- Joined
- Sep 14, 2022
- Messages
- 15
- Office Version
- 2019
- Platform
- Windows
Hello. Is there a way to create multiple formulas in one cell? In the one cell, I want to create a formula to multiply one cell by 0.45 and then I want to round that number to the nearest whole number (i.e., if it's $112.59, I want it to round to $113.00 or if it's $112.49, I want it to round to $112.00), but I only want the number to round if it is over $50.00, but it if it under $50.00, then it keeps the number of the cell multiplied by the 0.45 (which was the very first part of the formula). Thank you.