How to ask Excel to get a value OR values from a set of data IF they (Values) are NEGATIV

**rasolrpd** · 04-16-2017, 05:29 AM

Hey guys

How to ask Excel to get a value OR values from a set of data IF they (Values) are NEGATIVE ?
Here I want to choose negative values from Column K and write them in front of them in Column J.And if the the values in K weren't negative,write "0" instead.
Capture.PNG

**sanram** · 04-16-2017, 05:42 AM

Write this formula in J9 :

Formula:

Please Login or Register  to view this content.

**JohnTopley** · 04-16-2017, 06:05 AM

Try

=MIN(0,[@مانده])

=MIN(0,K9)

Copy down

**rasolrpd** · 04-16-2017, 06:37 AM

Originally Posted by JohnTopley

Try

=MIN(0,[@مانده])

=MIN(0,K9)

Copy down

Thanks a lot ! ,My question is answered.

How to ask Excel to get a value OR values from a set of data IF they (Values) are NEGATIV

LinkBack

Thread Tools

Rate This Thread

Display

How to ask Excel to get a value OR values from a set of data IF they (Values) are NEGATIV

Re: How to ask Excel to get a value OR values from a set of data IF they (Values) are NEG

Re: How to ask Excel to get a value OR values from a set of data IF they (Values) are NEG

Re: How to ask Excel to get a value OR values from a set of data IF they (Values) are NEG

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Having trouble forcing Excel to plot data values instead of index values

[SOLVED] Having trouble forcing Excel to data values instead of index values plot

[SOLVED] Having trouble forcing Excel to data values instead of index values

Excel Charting Problem: Vertical Axis Values vs. Secondary Data Series Values

data validation : List , data from single cell conatining (multiple values) VALUES

Displaying a graph with RED if the values are negativ

error calculating negativ difference time values

Bookmarks

Bookmarks

Posting Permissions