Is there a way to use the If function to see if a cell contains text? I am aware of the ISBLANK and ISTEXT functions but they won't work for me. I have a pretty lengthy formula that I finally got sorted out and don't feel like starting over with it, and need a FALSE returned if there is no text in the box.
Hey Butcher,
I'm not sure why ISTEXT won't work but without context this is what I came up with:
Formula:
Please Login or Register to view this content.
-Melk
When I try ISTEXT, the cell I reference with it has a formula in it but no value displayed. ISTEXT still recognizes the cell as having text in it, so I get a True result.
The type formula is also returning a true value despite nothing displayed in the cell.
What is the formula of the cell you are testing for text? Perhaps it is set equal to "" ? if that is the case you could do an if function first such like:
where X would be your function checking for text (ISTEXT or TYPE)Formula:Please Login or Register to view this content.
Training Stats, upload.xlsm
Here are the specifics of my problem.
On the Calculator sheet, cell O31 is saying "if cell O30 displays no text, and a certain cell (with Week 1 and Day 1 selected in the dropdown menus it is A6 on the training plan) is blank, then display the text in 'Training Plan'!B6.
What I want to happen is if cell O31 does not display any text, then the cells below it will also not display any text. I can not come up with the logic to do that, while also analyzing the offset cell reference for any text.
The purpose is so that I do not end up displaying any data that is outside of the Week and Day dropdown menu selection. Right now every day contains 3 rows of data, however in the future it might be modified to be more or less and I want to have a set of formulas that will adapt to that and display only relevant data.
Looks like you're working really hard to accomodate a datatable with some crummy design choices.
Can you improve the table to make outputting from it easier?
Like attached.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
The database works for me due to the format that it is printed in. I haven't ever used pivot tables but will look into those. Thanks all for the assistance. I realized what I am trying to do is accomplished by nesting 2 IF formulas so I am marking this as solved. I do appreciate the assistance though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks