Thanks for the explanation
Posts by slick225
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?
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
Can I add to the ISTEXT formula to change the True/False default to Resolved/Unresolved?
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.
Please Disregard this Post.
But for anyone wanting to know the answer:
K5 contains the value 18
results of the formula was 20
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?
Thanks in Advance
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)
Andy thanks, the color format is now in place, but I'm having some issues with the formula.
More detail on the layout
2...........Status................Expire Date...........Todays Date
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.
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?)
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.
I want to add a list of time ranges to a worksheet.
8:00 - 8:30
8:31 - 9:00
9:01 - 9:30
How can this be done easily in excel?
Again thanks in Advance
Richie(UK) that was a great solution as well.
Thanks Domenic and REP013 that helped, and formatting the cell to dddd (custom setting) worked like a charm.
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?
Again, Thanks in Advance