LinkBack URL
About LinkBacks
I need to create a formula where if Cell G has certain text value, then Cell H is going to equal something. For example: If Cell G = SFS A, then Cell H = $20 Flat Fee, if Cell G= SFS B, then Cell H = $30 Flat Fee. Please Help!!!
IF Formula?
I need to create a formula where if Cell G has certain text value, then Cell H is going to equal something. For example: If Cell G = SFS A, then Cell H = $20 Flat Fee, if Cell G= SFS B, then Cell H = $30 Flat Fee. Please Help!!!
Hi BETZY,
Welcome to the forum.
Create a lookup table somewhere on the sheet with all the possible texts and their corresponding values and then in col. G input texts and in col. H, use a Vlookup function to get the desired output based on the text in corresponding cell in col. G.
If you are unable to work with this, please attach a sample workbook.
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hi and welcome to the forum.
One way
=IF(G1="SFS A","$20 Flat Fee",IF(G1="SFS B","$30 FlatFee",""))
But if you have a lot of values like SFS A, SFS B etc. you'd be better advised to create a table of these along with their associated results and use a VLOOKUP rather than many IF tests.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Re: IF Formula?
Hello sktneer,
Attached please find a sample of what I need. I have approximately 2,500 patients that I need to populate into this chart and I would like to once I add SFS A, SFS B, SFS C or Self Pay, the Fee Column to automatically populate by itself instead of me doing it manually.
Thank You very much for your help!
Betzy
Originally Posted by sktneer
Hello Richard,
I tried your formula, and it partially worked. For the SFS A it comes back fine, but for the B, I get a FALSE result. I've been trying and trying and I can't seem to get it right.
Thank you for your help,
Betzy
Hi
Are you sure you have "SFS B" and not say "SFS B " with perhaps a trailing space.
Upload the workbook so that we can check to see how you've implemented the formula.
Using a table, with your 4 options in your example, you could use
easily. However, if something is inserted into the G-cell that is not on the table, it's going to throw an #N/A error at you.
Please Login or Register to view this content.
If you use Richard's code, only your options will give you a response, all others will stay blank.
Please see the attached example, I have modified Cells G2:H4 with the formulas.
Oh! I get it.
I need rep--->҉
You dont really give is much to work on, but I agree with the other suggestions that you create a small table with your discount levels and relative fee, then use a vlookup to pull inteh answers.
I would als add, that instread of having "$xx Flat Fee", you put the money (as a value) in 1 column, and the description in another column. That way, you can run calcs in the Fee if needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks