SOLVED

Highlighted
New Contributor

# New Member - Formula Help

Hi Community,

I have just signed up with a view to expanding my excel knowledge. For the last few days, I have been searching for a formula to help me, but have not found it, so I am turning to the Excel Guru Community. Thanks in advance for all help.

Scenario:

I have 4 columns on a spreadsheet (E to H). Based on the specific text in Columns E and G, I want to return certain values. Ideally, column H would total also.

For example:

If E4 is Not App. and G4 is Issued, H4 = 150

If E4 is Complete and G4 is Issued, H4 = 318

If E4 is Issued and G4 is Not App., H4 = 168

Is there a formula I can use for this and then fill down for the rows below?

I have attached a simple version showing the scenarios. Any help would be greatly appreciated, as this is now frustrating me greatly.

Thanks.

5 Replies
Highlighted

# Re: New Member - Formula Help

You defined the logic only for 3 combinations

What formula shall return for other ones?

Highlighted

# Re: New Member - Formula Help

With Thanks,

Highlighted
Best Response confirmed by Eddy_the_Surveyor (New Contributor)
Solution

Highlighted

# Re: New Member - Formula Help

That's Brilliant. Thank you.

Best Regards,

Eddy

Highlighted

# Re: New Member - Formula Help

@Eddy_the_Surveyor This is better, I believe. Have removed the hard-code 150, 168 and 368. Used links to the numbers above the table in stead.