Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Cell equals zero or another cell in IF statement
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-2014, 01:18 PM
dirtboy dirtboy is offline Cell equals zero or another cell in IF statement Windows 8 Cell equals zero or another cell in IF statement Office 2013
Novice
Cell equals zero or another cell in IF statement 		 
Join Date: Jun 2014
Posts: 2
dirtboy is on a distinguished road
Default Cell equals zero or another cell in IF statement

i am trying to use the IF statement for a cell to be 0 if another has the word no (true) or make the cell equal another if false. i keep getting an error that it recognizes = as a formula and it tells me to use an apostrophe but then it says the first character isn't valid.

Here is the IF statement i am trying to use

=IF(O2=no,0,=Q2)

any help would be greatly appreciated.
Reply With Quote
  #2  
Old 06-20-2014, 01:36 PM
Mjpunj Mjpunj is offline Cell equals zero or another cell in IF statement Windows 7 32bit Cell equals zero or another cell in IF statement Office 2010 32bit
Novice
  
Join Date: Jun 2014
Posts: 7
Mjpunj is on a distinguished road
Default
=IF(ISNUMBER(SEARCH("no",O2)),"0",Q2)
Reply With Quote
  #3  
Old 06-20-2014, 01:42 PM
Mjpunj Mjpunj is offline Cell equals zero or another cell in IF statement Windows 7 32bit Cell equals zero or another cell in IF statement Office 2010 32bit
Novice
  
Join Date: Jun 2014
Posts: 7
Mjpunj is on a distinguished road
Default
Sorry, I just saw that you wanted the cell to equal another cell if false. I hope that works for you!
Reply With Quote
  #4  
Old 06-20-2014, 01:44 PM
dirtboy dirtboy is offline Cell equals zero or another cell in IF statement Windows 8 Cell equals zero or another cell in IF statement Office 2013
Novice
Cell equals zero or another cell in IF statement 		 
Join Date: Jun 2014
Posts: 2
dirtboy is on a distinguished road
Default
works awesome. thank you very much
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell equals zero or another cell in IF statement How to input the text of a cell into another cell automatically ？ Juliet Excel 1 03-15-2013 03:25 AM
Change formula cell range based on cell value Scoth Excel 4 10-25-2012 07:51 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM
Cell equals zero or another cell in IF statement IF statement that adds text to a cell themangoagent Mail Merge 4 08-26-2009 08:07 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:19 AM.

Contact Us - Privacy Statement - Top

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