using IF function for negative numbers

**jlahti** · 02-01-2019, 06:59 AM

Hey guys,
My relatively simple problem is the following; I have 3 columns of data, and in each row I would like to identify the MIN number but only if all 3 values are negative.

So for example, -2, -3, 5 would not give me anything, but -2, -3, -4 would give me -4.

Thank you in advance!

- Johan

**PaulM100** · 02-01-2019, 07:09 AM

Try:

=MIN(IF( A2:C2<0, A2:C2)) array entered Ctrl+Shift+Enter pressed at the same time instead of regular Enter

**Roel Jongman** · 02-01-2019, 07:09 AM

try

Formula:

Please Login or Register  to view this content.

**tim201110** · 02-01-2019, 07:12 AM

=iferror(aggregate(15,6,b1:d1/(countif(b1:d1,"<0")=columns(b1:d1)),1),"")

**jlahti** · 02-01-2019, 07:22 AM

Thanks for the help!!

**jlahti** · 02-01-2019, 07:24 AM

Appreciate it! It works well.

using IF function for negative numbers

LinkBack

Thread Tools

Rate This Thread

Display

using IF function for negative numbers

Re: using IF function for negative numbers

Re: using IF function for negative numbers

Re: using IF function for negative numbers

Re: using IF function for negative numbers

Re: using IF function for negative numbers

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] MROUND function with negative numbers

Convert negative numbers to positive numbers using Excel "Find and Replace" Function

If function negative numbers

[SOLVED] Function for set of numbers being all positive or negative

how to use IF function with negative numbers

[SOLVED] I get some negative numbers when I use the RAND() function--Why?

[SOLVED] how do i use excel's natural log function with negative numbers?

Bookmarks

Bookmarks

Posting Permissions