Home

IF Formula trouble

Highlighted
Killian17
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

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)

 

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
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
205 Replies