I have a spread sheet with product prices.

One column has old prices, another has new prices for some products.

I need a function to look and see if there is a new price and multiply
it by one percentage if it is less than 1000 and multiply it by another
if it is not.

If there is not a new price, then the function needs to look at the old
price for the same numbers.

I have tried several different ways to write this nested if statement.
For the most part, Excel says there is an error. The one time I didn't
get an error it also didn't work correctly.

Does someone have a clue how to do this?


--
stillgreen
------------------------------------------------------------------------
stillgreen's Profile: http://www.excelforum.com/member.php...o&userid=31718
View this thread: http://www.excelforum.com/showthread...hreadid=514219