Home

IF Formula trouble

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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies