Multiple Yes / No If Options

[mycon73]

Hi

I have a table with multiple Yes / No options

The idea is that we are weighing something & subtracting "if" Item B is used, which weights 15 lbs.

"If" Item C is used, then another 43 pounds is subtracted

Trying to get function that has Yes / No scenarios, which may be both No's, one of each or both Yes'

For example:

Item A weights: 585 pounds (Cell D6)

If both B (Cell E6) & C (Cell F6) items are used then would have: 585-15-43 = 527

Looking to modify function to manage the Yes / No scenarios


=IF(D6="","",D6-15-43)

Thanks

[63falcondude]

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

[mycon73]

Hi

Yes / No Scenarios example file submitted

[Sam Capricci]

here is one way...
=IF(AND(E5="y",F5="y"),D5-(15+43),IF(E5="y",D5-15,IF(F5="y",D5-43,D5)))

[mycon73]

Sambo Kid

Great Solution!!!

[Sam Capricci]

Glad I could help, AND thank you for the rep!