software

Hello there,

I am wondering if anyone can help. I am working on a sheet and I need
to be able to do a quot; if and or formulaquot;

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 quot;either or type equationquot;

Any help really appreciated--
chockee
------------------------------------------------------------------------
chockee's Profile: www.excelforum.com/member.php...oamp;userid=31886
View this thread: www.excelforum.com/showthread...hreadid=516133In L7 enter something like:

=IF(D7=quot;Product 1quot;,J7,M7/Q7*1000)

--
Jim
quot;chockeequot; gt; wrote in
message ...
|
| Hello there,
|
| I am wondering if anyone can help. I am working on a sheet and I need
| to be able to do a quot; if and or formulaquot;
|
| 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 quot;either or type equationquot;
|
| Any help really appreciated
|
|
| --
| chockee
| ------------------------------------------------------------------------
| chockee's Profile:
www.excelforum.com/member.php...oamp;userid=31886
| View this thread: www.excelforum.com/showthread...hreadid=516133
|

Jim, thanks for the reply

I was wondering was if I implement

=IF(D7=quot;Product 1quot;,J7,M7/Q7*1000)

As I am looking to work against 2 products

would it look like

=IF(D7=quot;Product 1quot;,J7,M7/Q7*1000)(D7=quot;Product 2quot;,=H7) so that the fixed
price items are transferred across

Hope I am making sense --
chockee
------------------------------------------------------------------------
chockee's Profile: www.excelforum.com/member.php...oamp;userid=31886
View this thread: www.excelforum.com/showthread...hreadid=516133My formula says in words: If the product named in D7 is quot;Product 1quot; and
return the fixed price in J7. If it's not quot;Product 1quot; then return the value
of the formula M7/Q7*1000.

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

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