Get instant live expert help on I need help with m2 in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Solved by F. F. in 13 mins
I HAVE THE FOLLOWING VARIABLES THAT SHOULD RESULT IN EITHER A COLUMN Y (CELL Y2) ANSWER OR A COLUMN P (CELL P2) ANSWER OR A COLUMN S (CELL S2) ANSWER. I2 needs to use: If E2 is <=72 and M2 is 0-2% then answer is Y2, IF E2is <=72 and M2 is >2% then the answer is P2, IF E2 is 73-84 and M2 is 0-1.5% then answer is Y2, IF E2 is 73-84 and M2 is >1.5% then the answer is S2 HERE'S WHAT I TRIED TO FORMULATE USING "IF" and "AND" FORMULAS. IF E2 <=72 + M2 0-2% = Y2 AND IF E2 <=72 + M2 >2% = P2 AND IF E2 = 73-84 + M2 0-1.5% = Y2 AND IF E2 = 73-84 + M2 >1.5% = S2 CAN YOU FIND A FORMULA THAT RESULTS IN AN ANSWER THAT SATISFIES ALL THE CONDITIONS?
Solved by A. S. in 27 mins
sFile = Format(Now(), "yymmdd") & " m2 " & Adres & " " & Opdrachtgever
Solved by S. H. in 27 mins
=IF(M2<=50000AND J2 = "Annually",470,355)
Solved by Z. C. in 24 mins
why is this not working : +SUMPRODUCT(--(A2:A9=M1), --(B2:B9>=EDATE(TODAY(),-M2)),D2:D9,C2:C9)/SUMIFS(D2:D9,A2:A9,M1,B2:B9,>EDATE(TODAY(),-M2))
Solved by Z. A. in 24 mins