Ask Experts Questions for FREE Help !
Ask
    dragster1091's Avatar
    dragster1091 Posts: 5, Reputation: 1
    New Member
     
    #1

    Apr 17, 2014, 08:20 AM
    Excel if then
    I have column B with a date, I have column C with a formula (I have =(B1+180) in column C) I need the text in cell c1 to be visible. How do I do this?

    Cheryl
    dragster1091's Avatar
    dragster1091 Posts: 5, Reputation: 1
    New Member
     
    #2

    Apr 17, 2014, 08:31 AM
    If / Then
    I am using excel 2010. I am an excel beginner. I have column b formated as a date. I have column C formated with the date from column B and adding 180. The formula in column C is: =(B2+180). This works fine. However, now I need to figure out how to only disply the information in column C if column B is filled in.
    EX:
    column A Column B Column C
    (info should not be visible in Column "C" if no
    info is in "B")
    Equipment # PM Complete date PM Due Date
    010-008-003 16-Apr 10/13/2014
    010-129 16-Apr 10/13/2014
    010-159 6/28/1900
    036-136 6/28/1900
    036-137 6/28/1900


    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #3

    Apr 17, 2014, 09:39 AM
    Try:

    =IfBlank(B2),"",(B2+180))
    dragster1091's Avatar
    dragster1091 Posts: 5, Reputation: 1
    New Member
     
    #4

    Apr 17, 2014, 12:11 PM
    Thank you for your quick reply, unfortunately I got an error message:
    "The formula you typed contains an error"
    I wish I could share the file or a screenshot with you.
    dragster1091's Avatar
    dragster1091 Posts: 5, Reputation: 1
    New Member
     
    #5

    Apr 17, 2014, 12:13 PM
    Attachment 45938
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #6

    Apr 17, 2014, 12:15 PM
    Sorry, my memory is failing. Try:

    =IF(ISBLANK(B2),"",B2+180)
    dragster1091's Avatar
    dragster1091 Posts: 5, Reputation: 1
    New Member
     
    #7

    Apr 18, 2014, 04:12 AM
    That works, thank you very much!
    :)
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #8

    Apr 18, 2014, 04:43 AM
    Glad to assist. Sorry for the brain fart.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to connect one excel sheet to other excel sheet [ 28 Answers ]

How to connect one excel sheet to other excel sheet.

Excel [ 1 Answers ]

I have a problem. I have a list about some pupils and I have already linked them another tables as you told me (Because they are in different classes). But now I need to sort these pupils in the main table by their grades. If I do this, it will also effect to another tables, and there would be...

How to link multiple excel sheets to one main source excel sheet [ 7 Answers ]

I have a master price list and multiple ( individule ) sheets for customers.. I would like to , when input data in the price list to link and update to all other sheets... ( I do not want to have a source sheet with tabs) Thanks

Excel [ 3 Answers ]

Well I want to learn how do I paste more than one columns or rows in the excel... because when I want to insert the rows in the middle ,only one row gets inserted... help me.

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.


View more questions Search