If-then formula?

		Microsoft Office Forums > Microsoft Excel > Excel
If-then formula?

FAQ

Thread Tools

Display Modes

SoMany If-then formula? 12-20-2020, 03:02 AM

Purfleet its so much easier to see... 12-20-2020, 06:11 AM

SoMany How about this example? I... 12-21-2020, 08:49 AM

Pecoflyer Your syntax is incorrect for... 12-20-2020, 09:41 AM

SoMany I got it now. It was a SUMIF... 12-21-2020, 09:02 AM

Purfleet Good stuff 12-21-2020, 09:13 AM

Pecoflyer Good show ! You could also... 12-22-2020, 01:12 AM

12-20-2020, 03:02 AM

SoMany

Windows 7 64bit If-then formula?

Office 2016

Advanced Beginner

Join Date: Oct 2016

Posts: 51

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))

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If or formula help	zhead	Excel	8	04-25-2018 07:09 AM
Formula Copy Row 2 Row But Next Column In Formula From Another Tab	TimG	Excel	3	04-16-2018 09:20 PM
IF Formula	Paula	Excel	2	09-21-2017 12:39 AM
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 PM.