Excel 2007 : Creating a formula with display limits

**grghhn** · 10-19-2009, 10:46 PM

Hello again.

I am writing a formula that involves multiple columns of data. While the bulk of the formula I am writing has to do with simple math, I am in need of a display function, where the answer will only be displayed if it meets some outside criterion. Such as:

=When D3,D4 are greater>150(ROUNDUP(AVERAGE(C3,D3),0)-B3)-I3)

**shg** · 10-20-2009, 12:29 AM

=if(min(d3, d4) > 150, roundup(average(c3, d3), 0) - b3 - i3, "")

**grghhn** · 10-20-2009, 02:59 PM

Awesome thanks!!

I have one more question.

I have one set of data that also regulates whether or not I can order those items, and it is a word. I can't figure out what function to use to justify the formula.

If the word is there I cannot order, and if it is not I can.

**Palmetto** · 10-20-2009, 05:55 PM

Is the word the same one all of the time or is it various words?
Is the word in a cell by it self or is it among other words all in a single cell?

It might be best if you uploaded a sample workbook showing the structure, some sample data and a manual example of your desired results.

**grghhn** · 10-20-2009, 11:14 PM

InvenMin Max Flag Comp NY Sold On Ordr
0 5 8 Unorderable 192 1341 0 0
8 14 21 3031 2000 16 5

That is the basic layout of my data. I can only make the order if the flag column is blank, like in data row two.
The column will either have and Unorderable or nothing at all.

This is what I currently working with.

=IF(J2>100,TRUE,FALSE)*(IF(K2>100,TRUE,FALSE)*(ROUNDUP(AVERAGE(G2,H2),0)-F2)-M2)