Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9,101
Default Formula True False help

Easy

wrap your formule iwth this

if((old_formula) = 1, "True","False")


"Lisa" wrote:

In a formula, I need the cell to display the word "YES" instead of true, and
stay blank if false.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can TRUE/FALSE be replaced by a formula? BCB Excel Discussion (Misc queries) 4 August 4th 06 06:29 AM
Easy formula to return a true or false motol Excel Worksheet Functions 1 July 4th 06 03:43 AM
INSTEAD OF FORMULA SAYING TRUE OR FALSE I WANT IT TO SAY something GG Excel Discussion (Misc queries) 3 March 15th 06 02:58 PM
Formula: If 2 values (in a range of six) are >3 then TRUE, FALSE IFfunction Excel Discussion (Misc queries) 2 October 10th 05 10:34 AM
True or False Formula? Jo New Users to Excel 3 December 24th 04 08:45 AM


All times are GMT +1. The time now is 09:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"