Excel calculation / formula 1

[ajduk1]

Hi
I have recently recieved a request from a colleague.
I have a query pulling prices for products, eg. the product no is in column A, price in column B, conversion factor in column C.
So I am pulling the product & Price via a query and need to add the conversion factor to column C.
Data example:
PROD PRICE (from Query) PRICE CONV CONV FACT
1234ab 14.95 14.95 1
2234ab 0.0653 65.30 1000
3234ab 0.2773 277.30 1000

so if the price from the query has more than 2 decimal points he needs the price to be multiplied by 1000 the converted price entered into the (PRICE CONV) column and a conversion factor of 1000 entered into the CONV FACT column.Otherwise if the price has 2 or less d/p it can remain as is.

Can anyone help.

AJ

AJD

 

[GlennUK]

And what if the Price from the Query was 0.06?

Putting that question aside for now, have a formula under the CONV FACT column of:

=IF(B2=ROUND(B2,2),1,1000)

and an ordinary multiplication under the PRICE CONV column, or the original price * factor.


Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[ajduk1]

Thanks Glenn you are a star. All sorted and all looks great.

Thanks again
Andrew

AJD