Thread: [Solved] If-then formula?
View Single Post
 
Old 12-20-2020, 03:02 AM
SoMany SoMany is offline Windows 7 64bit Office 2016
Advanced Beginner
 
Join Date: Oct 2016
Posts: 51
SoMany is on a distinguished road
Default If-then formula?

Ok, I need help. I took two formulas and tried to combine them to make I sort of If-Then formula. If LEFT is true, then count the amount to the right. Please help!

=IF(([Orderfilling.xlsx]LEFT(Sheet1!K5:K50),"CP"=TRUE, SUM([Orderfilling.xlsx]Sheet1!L5:!L50))



Edit: Actually, this formula is probably close to what I'm trying to do, but still flawed;
=IF(ISNA([Orderfilling.xlsx]Sheet1!K5:K50,"CP"=TRUE, SUM([Orderfilling.xlsx]Sheet1!L5:!L50))
Reply With Quote