Hello,
I have several if statements which I want to add and they are as follows:
=(IF(L3="","",IF(K3="",D3,K3))) + (IF(L4="","",IF(K4="",D4,K4))) + (IF(L5="","",IF(K5="",D5,K5))) + (IF(L6="","",IF(K6="",D6,K6)))+so on up to 38.
I was wondering instead of adding each IF statement separately, is there any formula that would make my life easier and shorten it?
Thanks in advance.
Until someone sends a shorter formula, this will work.
HTML Code:
1. Click on the * Add Reputation if you think this helped you
2. Mark your thread as SOLVED when question is resolved
Modytrane
Excel 2019 has a IFS statement function which can make your life simpler.
From an office site:https://support.office.com/en-us/art...b-4a39bd951d45
Please Login or Register to view this content.
I haven't had the occasion to mess with it, but it looks helpful.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks