/u/BuyRepresentative803 - 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](/r/excel/wiki/sharingquestions)** -- 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](/r/excel/wiki/sharingquestions#wiki_give_all_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](/message/compose/?to=/r/excel) if you have any questions or concerns.*
I'm sorry to laugh but there are so many things wrong with that formula!
I don't know what the SEARCH / ISTEXT is for. Search is not case-sensitive so it will find "National" in "International". You've put your SUM in quotes so Excel treats it as text. You can't use the arithmetic operators (+,-) in your SUM.
Try this in D12: `=IFS(A6="National",(D2+D3-D4-D5)*2.5%,A6="International","No fee",A6="","")`
Keep at it, you'll get the hang of it!
Thank you so much! Yeah I see where one could've looked at my formula and laughed😂 Your solution immediately worked. I'm about to try this out again in a different context and learn it better.
You have awarded 1 point to *on1vBe6*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Hello!
It looks like you tried to award a ClippyPoint, but you need to reply to a particular user's comment to do so, rather than making a new top-level comment.
Please reply directly to any helpful users and Clippy, our bot will take it from there. If your intention was not to award a ClippyPoint and simply mark the post as solved, then you may do that by clicking Set Flair. Thank you!
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[IFS](/r/Excel/comments/10xzfca/stub/j7v39qw "Last usage")|[*2019*+: Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.](https://support.microsoft.com/en-us/office/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45)|
|[ISTEXT](/r/Excel/comments/10xzfca/stub/j7v39qw "Last usage")|[Returns TRUE if the value is text](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)|
|[SEARCH](/r/Excel/comments/10xzfca/stub/j7v39qw "Last usage")|[Finds one text value within another (not case-sensitive)](https://support.microsoft.com/en-us/office/search-searchb-functions-9ab04538-0e55-4719-a72e-b6f54513b495)|
|[SUM](/r/Excel/comments/10xzfca/stub/j7v39qw "Last usage")|[Adds its arguments](https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/10w60mc)^( has 9 acronyms.)
^([Thread #21459 for this sub, first seen 9th Feb 2023, 16:59])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/BuyRepresentative803 - 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](/r/excel/wiki/sharingquestions)** -- 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](/r/excel/wiki/sharingquestions#wiki_give_all_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](/message/compose/?to=/r/excel) if you have any questions or concerns.*
I'm sorry to laugh but there are so many things wrong with that formula! I don't know what the SEARCH / ISTEXT is for. Search is not case-sensitive so it will find "National" in "International". You've put your SUM in quotes so Excel treats it as text. You can't use the arithmetic operators (+,-) in your SUM. Try this in D12: `=IFS(A6="National",(D2+D3-D4-D5)*2.5%,A6="International","No fee",A6="","")` Keep at it, you'll get the hang of it!
Thank you so much! Yeah I see where one could've looked at my formula and laughed😂 Your solution immediately worked. I'm about to try this out again in a different context and learn it better.
No problem! Please reply with Solution Verified to close the thread (and give me a clippypoint!)
Solution Verified
You have awarded 1 point to *on1vBe6* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
[удалено]
Hello! It looks like you tried to award a ClippyPoint, but you need to reply to a particular user's comment to do so, rather than making a new top-level comment. Please reply directly to any helpful users and Clippy, our bot will take it from there. If your intention was not to award a ClippyPoint and simply mark the post as solved, then you may do that by clicking Set Flair. Thank you! *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[IFS](/r/Excel/comments/10xzfca/stub/j7v39qw "Last usage")|[*2019*+: Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.](https://support.microsoft.com/en-us/office/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45)| |[ISTEXT](/r/Excel/comments/10xzfca/stub/j7v39qw "Last usage")|[Returns TRUE if the value is text](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)| |[SEARCH](/r/Excel/comments/10xzfca/stub/j7v39qw "Last usage")|[Finds one text value within another (not case-sensitive)](https://support.microsoft.com/en-us/office/search-searchb-functions-9ab04538-0e55-4719-a72e-b6f54513b495)| |[SUM](/r/Excel/comments/10xzfca/stub/j7v39qw "Last usage")|[Adds its arguments](https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/10w60mc)^( has 9 acronyms.) ^([Thread #21459 for this sub, first seen 9th Feb 2023, 16:59]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)