Excel formula assistance

[Na$$]

Hi Excel experts,

I need a formula that can calculate the recommended price based on the below conditions:

Price guide:
A = $2.00

Current price: (enter value here)

Recommended price:................

Conditions:
- If current price is less than price guide, then increase current price by 6.45% > display value in recommended price, however...

when price is increased by 6.45%, it can not exceed the price on price guide > display price guide price in recommended price

- If current price is greater than the price guide, display current price as recommended price.

I'm hoping this can all be done in one formula. Appreciate your assistance. Cheers.

 

[Andrew Poulsom]

Is it?

=IF(A2 < A1,MIN(A1,A2*1.0645),A1)

 

[VoG]

With recommended in A1 and current in A2 try

=IF(A2>A1,A2,MIN(A1,A2*1.0645))

 

[abmati]

Please try the following:

Excel Workbook
	A	B
1	$ 100.00	Price guide
2	$ 105.00	Current price
3	$ 105.00	Recommended price
Sheet1

Regards,

 

[Na$$]

Thank for your help