Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-02-2021, 10:55 PM
Des ONeill Des ONeill is offline Condtional function to operate a formula based on "Yes" or "No" Windows 10 Condtional function to operate a formula based on "Yes" or "No" Office 2019
Novice
Condtional function to operate a formula based on "Yes" or "No"
 
Join Date: Jul 2021
Posts: 2
Des ONeill is on a distinguished road
Thumbs up 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
Reply With Quote
  #2  
Old 07-02-2021, 11:12 PM
Purfleet Purfleet is offline Condtional function to operate a formula based on "Yes" or "No" Windows 10 Condtional function to operate a formula based on "Yes" or "No" Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

This?

=A1="Yes"
Reply With Quote
  #3  
Old 07-03-2021, 12:14 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Condtional function to operate a formula based on "Yes" or "No" Windows 7 64bit Condtional function to operate a formula based on "Yes" or "No" Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Your question is not very clera
Perhaps
Code:
=IF(A1="yes", your_formula,"")
Reply With Quote
  #4  
Old 07-03-2021, 12:16 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Condtional function to operate a formula based on "Yes" or "No" Windows 7 64bit Condtional function to operate a formula based on "Yes" or "No" Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

This is a duplicate thread https://www.msofficeforums.com/excel...condition.html
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Condtional function to operate a formula based on "Yes" or "No" 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
Condtional function to operate a formula based on "Yes" or "No" "Table of content" based on "Normal Style" behavior!!!! Jamal NUMAN Word 4 07-08-2011 04:12 AM
Condtional function to operate a formula based on "Yes" or "No" How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft