Determine if expression is equal, greater, or less than a cell value

**Pgraves7** · 05-10-2018, 10:11 PM

I can seem to find the formula for a plus/minus or over/under whatever you might call it.

So I'm looking for something like this.

A1+A2-A3=A4 or should =A4

I need to figure out if those numbers equal A4 < A4 or > A4.

Please and thank you for the help.

**6StringJazzer** · 05-10-2018, 10:17 PM

Welcome to the forum!

As a new member please take the time to review our rules. There aren't many, and they are all important.

Rule #1 requires good titles, and I'm sorry, but yours is not good. I am going to change it for you since it's your first post, but please get familiar with the rules for the future.

I think you want something like this:

Formula:

Please Login or Register  to view this content.

**FDibbins** · 05-10-2018, 10:22 PM

Hi, welcome to the forum

Not really sure what you expect the answer to look like, but this may get us started...

=if(a1+a2+a3=a4,"equal",if(a1+a2+a3<a4,"less than","greater than"))

edit: hey Jeff, there is almost an echo in here

**Pgraves7** · 05-10-2018, 11:13 PM

Hi Jeff thanks for the help.

I am looking for the number value of those numbers not the true and false the =if has been giving me. any.

It's more of like a inventory worksheet to find out if I am breaking even falling short or coming over my ended number.

maybe this might help

Start number+ordered number-what was sold=what number, then that number should should equal what I have in stock if not how many am I missing or how many do I have over

**6StringJazzer** · 05-11-2018, 09:53 AM

Originally Posted by Pgraves7

I am looking for the number value of those numbers not the true and false the =if has been giving me. any.

It's more of like a inventory worksheet to find out if I am breaking even falling short or coming over my ended number.

maybe this might help

Start number+ordered number-what was sold=what number, then that number should should equal what I have in stock if not how many am I missing or how many do I have over

If you want a better answer then it would if you actually showed what you want the result to look like. Attaching your file would be even better.

Given this latest description I would say you want simple arithmetic:

=A1+A2-A3-A4

If it's positive, it is how many over what you have in stock; if negative, it is how many under what you have in stock; if 0, it's a match.