Need clarity with IFS function in Google Sheets with multi criteria-CodePudding

Home > Net > Need clarity with IFS function in Google Sheets with multi criteria

Need clarity with IFS function in Google Sheets with multi criteria

Time：01-31

I'm trying to keep the numbers in "Inv.No." till 3-digits only having condition that either of the two specific cells are not empty. I am unable to do that after No.10. Below are few of the codes that I've tried with IFS function. Please note that the all cells have been kept to be "Numerical", the first is [(E5) = "00"&1 ]

Codes: =ifs(OR(I15="",E14=""),"",if(OR(E14>1,E14<9),"00"&(E14 1),"0"&(E14 1)))

=ifs(OR(I11="",E10=""),"",OR(E10>1,E10<9),"00"&(E10 1))

Page link：https//www.codepudding.com/net/283156.html

Prev:My code just return first product information

Next:Subtract 3 Columns in Google Sheet at Once

Tags：

Links：
CodePudding