PC Review


Reply
Thread Tools Rate Thread

How to Keep Excel from saying False in an If formula?

 
 
New Member
Join Date: Oct 2012
Posts: 1
 
      13th Oct 2012
This is the formula that I have IF(F8<>"","ONSITE") which means if there is anything in the F8 field I want the cell to say "onsite" but when there is nothing in F8 it says False. How to I have it just be blank without saying false?
Thanks for anyones help!
 
Reply With Quote
 
 
 
 
Senior Member
Stoneboysteve's Avatar
Join Date: Sep 2008
Location: USA
Posts: 155
 
      13th Oct 2012
Hi,

This formula leaves the cell blank:
=IF(F8<>"","onsite","")

The syntax says if the condition (F8 is not blank) is true, the value is "onsite". If the condition is false the value is """" (blank).

Stoneboysteve
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
My IF function is saying something is false when it is true... dilbert16588 Microsoft Excel Worksheet Functions 2 11th Apr 2008 07:00 AM
VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007 Matt Simpson Microsoft Excel Programming 0 6th Aug 2007 08:11 PM
$C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give # =?Utf-8?B?U3RldmVk?= Microsoft Excel Worksheet Functions 6 3rd Jul 2006 01:49 AM
INSTEAD OF FORMULA SAYING TRUE OR FALSE I WANT IT TO SAY something =?Utf-8?B?R0c=?= Microsoft Excel Misc 3 15th Mar 2006 03:58 PM
keep getting popup saying i have a trojan horse =?Utf-8?B?Y3JhaWdzYQ==?= Windows XP General 3 29th Jun 2004 11:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:45 PM.