#1
|
|||
|
|||
Condtional function to operate a formula based on "Yes" or "No"
I need a function/ formula to operated subject to a yes or no condition. That is, I want to use a conditional function in excel to operate a formula subject to a "Yes" or "No" Condition where I only want the formula to operate with the Yes Condition is in a cell and not operate if a No Condition is in that same cell |
#2
|
|||
|
|||
This?
=A1="Yes" |
#3
|
||||
|
||||
Your question is not very clera
Perhaps Code:
=IF(A1="yes", your_formula,"") |
#4
|
||||
|
||||
This is a duplicate thread https://www.msofficeforums.com/excel...condition.html
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to format "I" column based on if "F" column row is not blank | ravl13 | Excel | 3 | 08-22-2017 12:26 PM |
Combine "sort within groups" and "identify duplicate/unique values" in two different variables. | civilcervant | Excel | 3 | 06-12-2017 07:27 AM |
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas | jocke321 | Word VBA | 2 | 12-10-2014 11:27 AM |
"Table of content" based on "Normal Style" behavior!!!! | Jamal NUMAN | Word | 4 | 07-08-2011 04:12 AM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |