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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies