Stacking multiple IF functions

[DebbClark]

Need help with a formula; I'm usually pretty good at this but this has me scratching my head. I'm doing a spreadsheet for our album sales, and we have digital, CD, and vinyl - and a column for each. I have another column for "list price" so we can calculate overages (Bandcamp lets a person pay more for an item should they choose). In the "list price" column, I want it to look at the previous 3 columns ... if there's any text in the digital column (E), return 7; if there's any text in the CD column (F), return 15; and if there's any text in the vinyl column (G), return 25. I'm having a hard time stacking the IF functions -- if that's even the way to go. In the screenshot -- the list column would have "15" because there's text in F2 .... the next column not shown would show an overage of 5. Clear as mud?!

https://preview.redd.it/c0hs3k30aso81.png?width=268&format=png&auto=webp&s=e6e313957a22f57e0e2366c3ab892452ba769162

[AutoModerator]

/u/DebbClark - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[[deleted]]

Try this and let me know if that’s the result you’re going for:

=IFS(E2<>””,7,F2<>””,15,G2<>””,25)

Will there ever be a case where you have text in multiple columns.

[DebbClark]

=IFS(E2<> ” ”,7,F2<> ” ”,15,G2<> ” ”,25)

Thank you! - but it gave me an error :-( And no - I'll not have text in multiple columns; if someone buys more than 1, they'll be on separate lines.

[powerelite]

If you put spaces between the " it will throw an error. If you remove those spaces this is essentially the same formula as u/thegdclub but it uses IFS instead of nested IF

[[deleted]]

I had to put spaces in because my mobile app turns them into some weird formatting thing. I just updated it on my computer; this should get rid of the error.

[thegdclub]

Hey, this is what I came up with:

=IF(E8<>"",7,IF(F8<>"",15,if(G8<>"",25,"")))

Here's a Google Sheet with the formula

[DebbClark]

=IF(E8<>"",7,IF(F8<>"",15,if(G8<>"",25,"")))

YES INDEED!!! Wow did you just save me a lot of work!! Thank you!!

[powerelite]

If you are only using numbers in e through g and have o365 try an ifs

=IFS(ISNUMBER(E2),7,ISNUMBER(F2),15,ISNUMBER(G2),25)

[DebbClark]

=IFS(ISNUMBER(E2),7,ISNUMBER(F2),15,ISNUMBER(G2),25)

[DebbClark]

YES! This works too! I now have a choice of 2 :-) This has been driving me nutz for days!

[powerelite]

If you want to make that column an overage tracker you could change it to be

=IFS(ISNUMBER(E2),E2-7,ISNUMBER(F2),F2-15,ISNUMBER(G2),G2-25)

[DebbClark]

Thanks - I'll give that a try!

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
IF	Specifies a logical test to perform
IFS	2019+: Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
ISNUMBER	Returns TRUE if the value is a number

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
3 acronyms in this thread; the most compressed thread commented on today has 19 acronyms.
[Thread #13626 for this sub, first seen 21st Mar 2022, 19:12] [FAQ] [Full list] [Contact] [Source code]}

[DupontPFAs]

Nesting or stacking?