use if condition expression when true as result

[sparc]

In many case using IF function in excel I must use if condition expression when true as value, example:

if(condition >=0;condition;expression when false)

if (5+3 > 0; 5+3; 0)

is there a shorter way for use

 

[pr2-eugin]

What is the problem with using the one you just got?

 

[sparc]

Problem is when conditional expression is long or very complex, ploblem is in readability formula , or a copy complex expression again. I use for example very simple expression.

 

[sparc]

function NZ in access 2013 removed a similar Problem with the function IsNull

 

[Mile-O]

If you press Alt+Return in your formula, you can move different conditions to new lines in order to space it out a bit.

 

[Rx_]

1. In modern versions of Excel 2013 and 2010, you can use up to 64 nested IF functions. In older versions of Excel 2003 and lower, up to 7 nested IF functions can be used.

2. once an IF formula includes more than 5 nested IF functions, you may want to optimize it by using the alternatives found here:
https://www.ablebits.com/office-addins-blog/2014/12/03/excel-if-function-iferrror-ifna/
The Array is very efficient if there are many records.