Forum Discussion

LORDPHILLIP's avatar
LORDPHILLIP
Copper Contributor
Sep 04, 2023
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...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Sep 07, 2023

    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.

LORDPHILLIP's avatar
LORDPHILLIP
Copper Contributor
Sep 06, 2023

mathetes 

 

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.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Sep 07, 2023

LORDPHILLIP 

=LET(Sz2Ft,ROUND(A2/12,2),

FstPass,C2/Sz2Ft,

Rmndr,FstPass-INT(FstPass),
Addr,IF(Rmndr=0,0,IF(Rmndr>=0.75,2,1)),

INT(FstPass)+Addr)

 

I've made slight modification to mathetes formula and it returns the intended result in my understanding.

 

For 94 SIZE IN INCH and 452 INPUT LF the correct answer should be 58 in my understanding.

94 / 12 = 7,83

452 / 7,83 =  57,72669

0,72669 is not between 0,75 and 0,99 therefore result should be 58.

 

Resources