IF cell is negative number, do this

**Shruder** · 03-26-2019, 04:03 PM

I am looking for a IF formula that will return a "N" if the cell is >45 or if the cell is (negative)-<45

Any suggestions?

Capture.PNG

**Fluff13** · 03-26-2019, 04:12 PM

How about

Formula:

Please Login or Register  to view this content.

or

Formula:

Please Login or Register  to view this content.

**AliGW** · 03-26-2019, 04:15 PM

Your sample data seems odd, as it does not meet the criteria, but try this:

=IF(OR(D2>45,D2<-45),"N","")

**Norie** · 03-26-2019, 04:16 PM

Try this.

=IF(ABS(N2)>45. "N")

**Shruder** · 03-26-2019, 05:55 PM

thanks all for responses. I was able to join some of the formulas together and it worked, this was the final formula used.

=IFNA(IFS(ABS(W2)>45,"N",ABS(W2)<-45,"N"),"Y")

IF cell is negative number, do this

LinkBack

Thread Tools

Rate This Thread

Display

IF cell is negative number, do this

Re: IF cell is negative number, do this

Re: IF cell is negative number, do this

Re: IF cell is negative number, do this

Re: IF cell is negative number, do this

Thread Information

Users Browsing this Thread

Similar Threads

Combine negative number with the number in cell next to it until the sum becomes positive

[SOLVED] If a cell contains a specific word and a number, make the number negative

[SOLVED] SUMIF positive and negative numbers - take double a negative number?

how to -Negative number transfer in other cell

Calculating The Largest Negative Number within a Range of Positive & Negative Numbers

cell to show ' 0 ' , or nothing at all, if the sum is a negative number

2003= negative number&2004= negative number How Do I Calculate gro

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions