# Posts by slick225

• ## Can ISTEXT display anthing other than True or False?

Thanks for the explanation

• ## Can ISTEXT display anthing other than True or False?

Brandtrock thanks, I used the formula =IF(ISTEXT(D2),"Resolved","Unresolved")
It was exactly what I needed.

I was curious about the 2nd formula: =IF(AND(ISTEXT(D2),LEN(D2)>1),"Resolved",Unresolved")

What is LEN? or what does it do?

• ## Can ISTEXT display anthing other than True or False?

Background: I'm using an ISTEXT formula for open cases to my support group, and I have a column for resolution, and another column for status. I want to formula that will do the following: If there is a resolution (text) in the resolution cell, the status cell will display the text resolved, but if the resolution cell is left blank the status cell should display the text unresolved.

Currently the formula: =ISTEXT(D2) results in True/False

Question:
Can I add to the ISTEXT formula to change the True/False default to Resolved/Unresolved?

• ## What Is The a formula to round up?

Thanks for the follow up, but Rounding up to the next 10 is exactly what I was trying to do. The calucation I needed requireds that sum of a series of numbers and then those numbers be rounded up to the 10th spot.

but, thanks again for the heads up.

• ## What Is The a formula to round up?

But for anyone wanting to know the answer:
=ROUNDUP(K5,-1)

Note:
K5 contains the value 18
results of the formula was 20

• ## What Is The a formula to round up?

Background: I have a cell with the value 18, I want to add a formula to round that up to next 10th, which would be 20.

Question:How can I do this?

• ## "IF" formula regarding a 3rd option, and automatic font color changes.

That did the trick Barbarr and it also simplified the process by eliminating an un-needed column (Today's Date).

Thanks for all your help (Andy P, and Barbarr)

• ## "IF" formula regarding a 3rd option, and automatic font color changes.

Andy thanks, the color format is now in place, but I'm having some issues with the formula.

More detail on the layout

Cell........I........................J.........................K
2...........Status................Expire Date...........Todays Date
3...........Expired..........................................9/16/2004
4...........Valid..................1/28/05.................9/16/2004

Intent: when todays date is greater than the expire date display the text Expired otherwise display Valid, but if there is no Expire Date display the text N/A.

Formulas:
Original formula for Cell I:3 - =IF(K3>J3,"Expired","Valid")
Results in cell I = Expired (I want this to display - N/A)

Original formula for Cell I:4 - =IF(K4>J4,"Expired","Valid")
Results in cell I = Valid (this is correct b/c the Expire date is greater than todays date.)

I tried what you suggested: in the I:3 cell - =IF(K3="","",IF(K3>J3,"Expired","Valid"))
Results in cell I = Expired (there was no change, did I need to add arguments?)

• ## "IF" formula regarding a 3rd option, and automatic font color changes.

Background: I have a spreadsheet and I'm using a simple formula (=IF(K5>J5,"Expired","Valid").
K5 is an expiration date, J5 uses the formula =Today().
If todays date is greater than the expiration date then the status should be Expired otherwise status will be Valid.

I have two questions:
1. not all entries will have an expiration date, so how can I add into the formula if the K5 is null display N/A?

2. Is it possible to have the font color change based on the status? (example: I'd like to have all Valid status appear in green, and all Expired appear in red.

• ## Adding a list of Times to a worksheet

I want to add a list of time ranges to a worksheet.
Example:
8:00 - 8:30
8:31 - 9:00
9:01 - 9:30
etc.

How can this be done easily in excel?

• ## Dates & Times in Excel

Richie(UK) that was a great solution as well.
Thanks

• ## Dates & Times in Excel

Thanks Domenic and REP013 that helped, and formatting the cell to dddd (custom setting) worked like a charm.

Thanks Guys

• ## Dates & Times in Excel

Hello, I'm new to the board, I've used Excel for years but I'm currently in a position where I need to use several formulas in excel for reporting to save myself some keystrokes. Thanks in Advance for any help.

Question 1: What is the command to get the current date w/o timestamp, to appear in a cell? (I've used '=NOW()' , but this formula includes the timestamp.

Question 2: Is there a formula that will display the current day?