How Do I Display Only Positive Results of a Formula in Excel? : Using Microsoft Excel

Subscribe Now:

Watch More:

Displaying only the positive results of a formula in Excel is a process that requires you to filter out results that you don't want to see. Display only the positive results of a formula in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.

Expert: Edward Russell
Filmmaker: Patrick Russell

Series Description: Microsoft Excel is a lot more than just a basic spreadsheet program - it can be a legitimately terrific way to keep track of nearly every type of information. Use formulas and columns in Microsoft Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video series.

[NatanLeon]

Man I've been scratching my head for hours trying to figure out the right formula till I watch your video.
This is my formula IF(E12≥5, E12−0.5, E12) E12 is the sum of two lined cells.
I appreciate taking the time to record this video. thanks a lot.

[grantw]

Jason may well have a shorter formula, however, like many of us that are somewhat neanderthal in our comprehension or grasp of making use of Formulas in Excel, your explanation made all the difference. Thanks Ted... Jason, maybe you can provide a link to elaborate on exactly how to use your shorter code =max(0, calculation)...? Reason I ask is because I cannot see where one makes reference to the negative total cell I need to exclude!

[iansimpson]

Many thanks for your clear and helpful video. I've been meaning to upskill myself onto "if" formulae for years and you've pushed me into it!

[PRI-Admin]

Many Thanks! very informational after watching many videos to complete the spreadsheet without showing negative values

[sujibean]

This was a very helpful and clear explanation of this! Thank you!

[WeRiders]

Thank you so much. its great help for me.

[hdtube]

This works well - if you want it to show the difference but only positive (i.e it's A-B but you want it to show that the gap is 6 whether it's plus 6 or minus 6) follow his instructions but for the last bit, instead of " " - put the same calculation in again but like this (K3-K2)*-1 that way it will make any negatives positive ONLY if the initial result is less than 0

[sayedahmaryam]

Your a good demonstrator.
Keep it up🎉

[gailsquires]

Brilliant! So clearly explained, Ted, thanks.

[jasonboatman]

Or a bit shorter:

=max(0, calculation)

[azhadshamim]

Can I see both positive and negative together
Just should show positive or negative
Thanks

[mohammadajhad]

Dear Sir, plz kindly make a video for the positive and negative value in same column

[guruprasadbm]

Thank you for sharing this video... I have 1 doubt "if value is negative result should show Loss, otherwise Profit".
Is it possible..? Is there any formula.?

[yurisavopulo]

What if my formula is very long and I don't want it to look like a mess by duplicating it. Is there another option? Thnx

[excusemybeauty]

I want to know how to get all positive numbers even if I subtract the small number to the larger number, how can I still make it positive, can excel rearrange it for me from big yo small so that I get positive?

[StondNinja]

Say I have two cells and I want to take the info from cell A and display it on cell B. But cell B can not display lower than 0 and also stop displaying after 1000? I can do the two things independently from each other but when I try to put the 2 IF together one overrides the other. Not sure if I should go about it a different way or if I just need to type the two IF formula correctly.
These are the 2 =IF(L9>1000, 1000, L9) =IF(L9<0, 0, L9). How do I make them one? Basically the cell needs to display the other cell from 0-1000 only, if that makes sense.

[ezequielgentilemontes]

Hi, Is it posible to put them together with no blanc cells?

[smgibson]

oh man, I don't use Excel, but  I've been trying to get that exact formula for my stock logsheet! thanks.

[joshpinales]

is there a formula that will show - or + with a set number in that column

[ITAdiExpert]

in this case the ms excel got very slow.. we should use if(a2-b2>=0, a2-b2, 0) instead of if(a2-b2>=0, a2-b2, )