+ Reply to Thread
Results 1 to 2 of 2

How to make this formula Blank cell.

  1. 05-27-2022, 04:32 PM #1
    Wskip49
    Wskip49 is offline
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    Excel 2021 for Mac
    Posts
    392

    How to make this formula Blank cell.

    I'm trying to get this formula to show blank if it does not = W or L,=IF(RIGHT(C3,1)="W",RIGHT(C3,1),"L")
    Reply With QuoteRegister To Reply
  2. 05-27-2022, 04:50 PM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: How to make this formula Blank cell.

    How about
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    or as you have 2021
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Last edited by Fluff13; 05-27-2022 at 04:53 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. If Statement to make a blank cell be equal to 0 even though it has a formula in it
    By thanhie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-08-2013, 11:19 PM
  2. formula to make cell blank instead of zero
    By disco dave in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 09-24-2013, 11:40 AM
  3. if cell is blank, can u make it say something by default using a formula?
    By teenyjem in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-07-2012, 01:04 AM
  4. Time on Duty, make cell blank unless reference cell in formula has data.
    By wtowers in forum Excel General
    Replies: 1
    Last Post: 12-17-2011, 10:14 AM
  5. Make a Formula Output a Blank Cell
    By Ortz in forum Excel General
    Replies: 3
    Last Post: 10-09-2011, 04:34 PM
  6. How to make a formula output a blank cell?
    By greggga in forum Excel General
    Replies: 3
    Last Post: 03-20-2009, 10:13 AM
  7. Help with formula to make cell return a blank
    By Ducatisto in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-19-2008, 09:36 AM
  8. How Do You Make A Formula Stop At A Blank Cell?
    By BZK in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2007, 05:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1