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!