Multiply three columns, if result over a certain number then put a warning

Hello,

I hope I am posting this in the right spot. I am fairly new to advanced Excel functions.

What I would like to do:

I have a spreadsheet with thousands of records. There are numbers in every row, in columns E, F and G.

I need Excel to, for every line, Multiply E x F x G. THEN, if the resulting product for that row is greater than say 1000, I want it to put the word "WARNING" in the currently empty J column for that row.

The J column has nothing in it at all right now in any row, I wanted it to be a new column where the formula can put results of the product for each row, so that I can then filter the J column to show only rows with "WARNING" in them, and then I can deal with them accordingly.


Thanks in advance for your help!

Hi

If we say that your data start in row 2 then try this an J2. Then copy down as you need.

=IF((E2*F2)*G2>1000,"warning","ok")

=IF(PutYourSumHere>1000,"Warning","")

Assuming your data starts in A2, place this in J2 and copy down.

=IF($E2*$F2*$G2>1000,"Warning","")

Windy