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...