Incorporating an IF statement into a formula with a double Vlookup comparison

[Kogen]

So I just got a lot of help with developing the formula for F39, but there is an additional factor I have to plan for; cell A43. It states that IF the total family size is greater than 6, then add an additional $5,150 for each dependent. It's cell has a text format also: "Adjusted Threshold for Families Larger Than 6 People "$#,##0.

Can this factor be incorporated into the existing F39 formula to only show up when the total family size is logged as being greater than 6, or do I need to change the A43 cell? I wanted it this way originally because 1) it's not very common to have families come in with a total size of 6, and 2) I didn't want to make a clunky list with all the myriad possibilities.

Excel Forum Example.xlsx

[6StringJazzer]

Formatting A43 like that seems overly complicated when you could put the number in E43 and the text in the cell to the left of it.

The comparison of VLOOKUP in F39 seems overly complicated, and it doesn't work for families over 6. It should be

Please Login or Register  to view this content.

But it is logically equivalent to

Please Login or Register  to view this content.

or even

Please Login or Register  to view this content.

You cannot incorporate the arithmetic into the F39 formula because the F39 formula produces text. Using A43 is the correct solution. But I don't see that you need to change anything--it's already there.

[jtakw]

Hi,

I don't understand why you chose the Longer, more complicated VLOOKUP formula compared to my simpler version that returns the Same result from your other thread.

This modified version of my formula from your other thread accommodates your new requirement for families of 7 or more.

Please Login or Register  to view this content.

See attached.

[FDibbins]

How is this different from your post here/
https://www.excelforum.com/excel-for...-a-result.html

[Kogen]

This worked wonderfully, thank you. I can understand why this question frustrated you; it's because I don't have enough experience with formulas beyond elementary formats. I'm not even sure how to break your formula down into pathway segments to follow the path.

[6StringJazzer]

Please respond to FDibbins question above. This appears to be a duplicate of another thread you started. We don't allow duplicates because people start answering both threads, creating confusion and possibly wasted effort.

[Kogen]

I was treating this post as an extension of the first post:
How to get the Vlookups to work together

Then,

How does the greater than 6 family members incorporate into the formula, and does it need to be adjusted.

Was this posted incorrectly?

[6StringJazzer]

The threads are so similar that they look the same to me, but you may not have intended them to be the same. The other thread looks resolved but PM me if you would like me to reopen it.

[jrammb]

Hi Friends,

I require help.... I have a table with different headers like "Task" B column, Sub-task in C column, Description in D Column, Month name in E Column, Hours spent in F Column... For example for the month of August after entering the daily activity I would like the summary of August in another sheet. Means the "Task" in B column will be repeated on different dates in August, I want the task (assume - Coordination") in different dates to be grouped together and the total hour of Coordination is diplayed...

[jtakw]

This worked wonderfully, thank you. I can understand why this question frustrated you; it's because I don't have enough experience with formulas beyond elementary formats. I'm not even sure how to break your formula down into pathway segments to follow the path.

Assuming you're responding to me, you're welcome.

[FDibbins]

jrammb welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[jtakw]

@Ford,

As Post # 9 is not posted by OP, I think it's more of a Rule 2 violation?

[FDibbins]

@Ford,

As Post # 9 is not posted by OP, I think it's more of a Rule 2 violation?

oops yes, you are correct. Apologies to jrammb for my quoting the wrong rule "(

[jtakw]

I think no apology needed Ford, so jrammb should open a new thread for his/her query.

[jrammb]

I think no apology needed Ford, so jrammb should open a new thread for his/her query.

Am sorry Ford and others... I will open a new thread. Thanks for the information.