Forum Discussion
Solved
IF/THEN and WILDCARD assistance
Good afternoon y'all, This will be a two-part question because my excel sheet has two areas that I need assistance with. Part 1 I have created an excel sheet that helps me calculate needed mate...
LORDPHILLIP Alternatively, and if you want to simplify it a bit enter this in D7:
=LET( a,C7/(A7/12), b,--(MOD(a,1)>=0.75), ROUNDUP(a,0)+b)and copy down.
Same principle but no need for an IF inside LET.
I've made some changes to the spreadsheet and attached the new version. I hope my changes can show a little more clearly what I am asking for, and I am sorry if it seems confusing.
You spoke correctly earlier saying that most of the information on these tables is clear and evident to me because I look at these numbers on the regular, and it becomes a little difficult to remember what needs more clarification.
Thank you so much for sticking with me on this. This is the final part I need help with in order to make this whole project usable and ready for the field. Again, please let me know if you have any questions or concerns, and/or need more clarification. I'm willing to break down any and all details to its lowest form if needed.
LORDPHILLIP Alternatively, and if you want to simplify it a bit enter this in D7:
=LET(
a,C7/(A7/12),
b,--(MOD(a,1)>=0.75),
ROUNDUP(a,0)+b)and copy down.
Same principle but no need for an IF inside LET.
I had to do some research to understand how that double negative works in that sexy formula you got from Riny_van_Eekelen If you understood it, you're a better man than I... but if you were happy that it worked but wondered how it did, here's the answer.
Here's one of the better explanations. You can also find some videos on YouTube by searching for "double negatives in excel"
- FANTASTIC! Thank you so much Riny van Eekelen! And thank you to everyone else as well for taking the time to help me!
