IF Formula trouble

Occasional Visitor

So I'm sure there's a way to do this, but my mind is going blank. I want to create something as a sort of "mark up" for a business project. Let's say if a certain value is greater than 75 I want to keep it, if it is less than or equal to 75 I want to add let's say an additional 25. How can I create that system? 

1 Reply



To do that, you can use IF function in the Nested IF form as follows:



If you have Excel 2019 or Office 365 installed in your machine, you can use IFS function which is the simplified version of Nested IF.



Nested IF VS IFS function.png 


Hope that helps