IF Formula trouble

[Killian17]

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? 

[#2]

Hi,

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

=IF(A1>75,A1,IF(A1<=75,A1+25))

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.

=IFS(A1>75,A1,A1<=75,A1+25)

 

Hope that helps