Hi,
Is it possible to combine the following two formulas:
=ROUNDDOWN(IF(D12<60,1010,1210)/B6,0) & =IF(D13<D7,1000000)
Any help would be appreciated.
Thanks.
Hi,
Is it possible to combine the following two formulas:
=ROUNDDOWN(IF(D12<60,1010,1210)/B6,0) & =IF(D13<D7,1000000)
Any help would be appreciated.
Thanks.
Is the first ROUNDDOWN formula in D13?
Are you then checking the outcome of this against D7?
Sorry, I just want to make sure that I've got the logic correct
Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.
Hi, I've attached the file. It's the workings sheet that I'm looking at.
Thanks.
How about this?
=IF(ROUNDDOWN(IF(D12<60,1010,1210)/D12,0)<D7,1000000,ROUNDDOWN(IF(D12<60,1010,1210)/D12,0))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for the file.
So If GRADE is HD, you want to divide SLABS by 2,500, then divide by LENGTH
and if GRADE is LD, you want to divide SLABS by 2,440, then divide by LENGTH
and if GRADE is neither of these, you want the answer in VOLUME to be 1,000,000
Just want to be sure that's the correct logic - it comes out with a very very small number!
Hi,
Even with your File I cannot understand exactly what you want
Can you explain in words carefully what you want the final formula to do
Thanks
Alan
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
I'm not sure that the OP is having an issue with the result of either formula: he (she?) just seems to want to combine them into one. We shall have to await his (her?) return to see who's right, however.
Thanks for the help and that works perfectly. I also need to combine the following formulas I've tried to replicate from your formula but failed. Any help would be appreciated:
=ROUNDUP(H12/F13,0) & IF(D13<D7,1000000))
The formula needs to go in cell I13 on the workings sheet.
Thanks
Try this:
=IF(D13<D7,1000000,ROUNDUP(H12/F13,0))
Again perfect thank you. Sorry to be a little vague but I'm trying to calculate a manual process for the shop floor that has allsorts of funny quirks...
Thanks.
You are very welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks