Avatar of u587162
u587162
 asked on

Urgent - simple excel formula needed please

Hi

Got a urgent question.

Could someone please help me write a basic formula in column D of the attached.
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
Microsoft Excel

Avatar of undefined
Last Comment
u587162

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Gary Dewrell

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
u587162

ASKER
This will have exactly the same effect as my formula above though right?
Gary Dewrell

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!
u587162

ASKER
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?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
EVeuger

then would be =MIN((A3*B3);C3)
(not ,C3 but ;C3)


Same result
u587162

ASKER
What difference does , or ; have?  Still works with ,?
Gary Dewrell

Yes you can also use. =MIN(A3*B3,C3)
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
EVeuger

, doesn't work with me (Excel2010)
Saqib Husain

Check this file
Copy-of-test-data.xls
u587162

ASKER
semi colon doesnt work, only comma works with excel 2007...or for me it does anyway.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Gary Dewrell

I am using 2010 also and it is working. Can you post your file again.
Saqib Husain

Did you check the file I attached?
Gary Dewrell

Sorry, missunderstood what you said. I thought you added the code I provided and it did not work.

Your sheet is working fine for me.   What results are you seing in Collum D?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
u587162

ASKER
=IF(A3*B3<C3,A3*B3,C3)  

Just to close off this one, how would I amend this statement so that it doesnt show #N/A or leave the cell blank if the other cells in the formula are blank?