# Urgent - simple excel formula needed please

Hi

Got a urgent question.

Basically I need the value to appear in each row of col D, so that the value is equal to either col B's percentage of the corresponding value in Col A or the value in col C.

Example for row 3.

7.9m x 8% = 0.632m.  This is lower than the 5m in Col C, so the value in Col D should be 0.62m

If Col C's figure was lower, then this figure would be taken.  I cannot remember how to use the MIN command here.  I think it is =MIN((B3*A3),C3)?

Thanks.
test-data.xls
Gary Dewrell

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
u587162

This will have exactly the same effect as my formula above though right?
It will compare the value of A4 x B3 against the value in Cell C3. Which ever value is smaller will be placed in D3.

I believe that is what your looking for. If not let me know.

Thanks!

Yes it is, but what I am asking is, your formula will have the same effect as =MIN((B3*A3),C3) as I posted in the question right, just another way of writing the formula?
then would be =MIN((A3*B3);C3)
(not ,C3 but ;C3)

Same result

What difference does , or ; have?  Still works with ,?
Yes you can also use. =MIN(A3*B3,C3)
, doesn't work with me (Excel2010)
Check this file
Copy-of-test-data.xls