Get instant live expert help on I need help with excel ifs function
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
=IFS(E16<=C16 AND(H16>1),"Good Job",E16>C16,"Too Much Time",TRUE,"Poor Quality")
Can AND be used with the IFS function? What am I missing. I can't seem to make this work.
Solved by F. S. in 16 mins
I created an excel spreadsheet with an IFS function in Excel 2016, but now I am not able to create a formula with that function. Is there an add-in that I need in order to use that formula?
Solved by S. Q. in 13 mins
I can't get the IFS function to work in the data validation excel 2010 drop down list
Solved by B. B. in 26 mins
how do i insert at least 3 criterias into a formula? tried using IFS function but it returned "NAME?"
Solved by S. H. in 19 mins
I need to use the IFS function to calculate commission based on annual sales.
>=225000 6%
>=175000 4%
>=100000 2%
<100000 0%
Solved by I. J. in 18 mins