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.
FANTASTIC! Thank you so much Riny van Eekelen! And thank you to everyone else as well for taking the time to help me!
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"