Evaluate Party Formulas in Excel
The Excel tutorial Today is pretty simple, but the truth is that it can save you a lot of time when you have problems with formulas in an excel template.nnSuppose we have a simple list of data like the one we see below:nn
nnn Then, we evaluate to do the following part function in Excel:n
=SI(F3<G3,F3*G3,F3/G3)
n Then, to achieve this we will simply have to press the key “F9“ Selecting the code we want to run, we can see a simple example below:nn
nnnnAs you can see in the image, even though the condition should give true, we are simply evaluating the second option and running without any problem, so it’s all within what it should be.nnThis little trick can save you a lot of time when we’re talking about formulas that are quite big. Excel tutorial have been helpful and do not hesitate to leave a comment if you have any doubts.