I have written lots of formulas in numerous spreadsheets that return a 0 instead of false. Although my current formula is written the same as the others, for some reason it returns false instead of 0. I have tried to fix it for hours with no success, have no idea what I'm doing wrong this time. What is wrong with the following formula?
=IF($J$5="Architectural",ROUNDUP(($H$5/33.3),0))
TryFormula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
change to: =IF($J$5="Architectural",ROUNDUP($H$5/33.3,0),0)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
any chance a space after architectural in J5 that returns a false, maybe there is an extra space.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
TMS and alansidman,
Thank you very much for your help. I copied and pasted the new formula and it got rid of the FALSE, but now it displays zero even if $J$5="Architectural".
I'll check that.
As SK has said, it is possible that cell J5 has leading or trailing spaces.
I checked that, no space. J5 is a drop down list. The user can select either "3-Tab" or "Architectural", which are shingle types. The formula is in a building material purchase order form. If the user selects "3-Tab", the formula calculates the quantity of this type of shingle needed on the appropriate line and returns a zero on the "Architectural" line. If the user selects "Architectural", vice versa.Originally Posted by Sambo kid
Its time to upload a portion (sample) of your file for analyzation. Otherwise, we are just guessing. Make sure that none of your information is confidential. Dummy that up if necessary.
TMS, alansidman and Sambo Kid,
Correction, I screwed up. That new formula is working now. I forgot to put data into H5, so zero was the correct calculation because H5 equaled zero. Again, thank you very much for your help.
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks