Hello there,

I am wondering if anyone can help. I am working on a sheet and I need
to be able to do a " if and or formula"

To explain

I am calulating formulas based on product lines

Product 1 - is always a fixed price
Product 2 - to work out the unit price a division needs to be made

All the additional figures for divisions are on the sheet but The
division formula is not a problem. So heres the example of what I am
trying to

If in D7 you select Product 1 as you already have the fixed unit price
in J7 it will copy the price to L7

But if in D7 if you select Product 2 it will do the division from other
rows
=(M7/Q7*1000) and will display the correct unit price in L7

So an "either or type equation"

Any help really appreciated


--
chockee
------------------------------------------------------------------------
chockee's Profile: http://www.excelforum.com/member.php...o&userid=31886
View this thread: http://www.excelforum.com/showthread...hreadid=516133