Sumifs / or function help

Something like this?

=IF(E1="Yes",A1+B1+(C1*2),IF(E1="No",SUM(A1:C1),"Nothing in E1"))

you should consider using Data Validation for the cell that someone will be entering this Yes, No. It can be found in the Data tab. Select "List" and type Yes,No into the textbox on the window. What this will do is turn the cell you have selected into a dropdown menu, so ONLY yes or no can be selected/entered into it

=if( E1="yes", A1 + B1 + (C1*2), IF( E1="NO", A1 + B1 + C1, "E1 does not a Yes or No"))

Or this

=IF(E1="yes",SUM(A1,B1,C1*2),SUM(A1,B1,C1))

You can use something like this

=IF(E1="Yes",(B1+C1)*2,B1+C1)

You have a few options, try this:

=(E1="yes")*(First formula here) + (E1<>"yes")*(Second formula here)


The (E1="yes")*( ) will become 1*( ) when E1 contains "yes", when E1 does not contain "yes" (E1="yes")*( ) will become 0*( ) or just 0.


This is the boolean logic method, you could also use IF(E1="yes", first formula, second formula)

Thank you for the feedback!

your welcome, thanks for the feedback

Glad to here, please mark your question "solved"

To mark your thread solved do the following:
New Method
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved

Old Method
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save