Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-31-2017, 07:19 PM
Cyberseeker Cyberseeker is offline IF Formula Question Windows 10 IF Formula Question Office 2010 32bit
Advanced Beginner
IF Formula Question
 
Join Date: Jun 2016
Posts: 44
Cyberseeker is on a distinguished road
Default IF Formula Question

Some help needed please. I have a cell that is usually left empty, and as such a different cell returns the result (lets say) "default wording" However, on occasions I type something different in the first cell, (lets say) "anything". In that case I want I want the second cell to produce the same word as typed in the first cell.

Here is my code in the second cell. Unfortunately it doesnt work. Can you tell me how to improve it?



Code:
=IF(cellwhatever="",default wording,IF(cellwhatever="anything",anything,))
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
nested IF formula question H28Sailor Excel 5 05-12-2017 11:01 PM
IF Formula Question Formula Question glhatch Excel 1 01-23-2015 04:13 PM
IF Formula Question Complex formula question diverdown87 Excel 7 10-21-2014 07:44 AM
Formula question H28Sailor Excel 4 08-20-2013 09:57 AM
IF Formula Question SUMIF Formula question jcaswell Excel 3 05-22-2011 02:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:41 AM.


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