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

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies