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!”
Here are some problems that our users have asked and received explanations on
=IF(L2<>"";L2;IF(M2<>"";M2;IF(J2<>"";J2)))
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