My formula says in words: If the product named in D7 is "Product 1" and
return the fixed price in J7. If it's not "Product 1" then return the value
of the formula M7/Q7*1000.

Since you mentioned only 2 products the "else" product would have to be
"Product 2" so there is no need to mention it specifically.

--
Jim
"chockee" wrote in
message ...
|
| Jim, thanks for the reply
|
| I was wondering was if I implement
|
| =IF(D7="Product 1",J7,M7/Q7*1000)
|
| As I am looking to work against 2 products
|
| would it look like
|
| =IF(D7="Product 1",J7,M7/Q7*1000)(D7="Product 2",=H7) so that the fixed
| price items are transferred across
|
| Hope I am making sense :)
|
|
| --
| chockee
| ------------------------------------------------------------------------
| chockee's Profile:
http://www.excelforum.com/member.php...o&userid=31886
| View this thread: http://www.excelforum.com/showthread...hreadid=516133
|