SteveStrummerUK Posted September 24, 2020 Share Posted September 24, 2020 Further to some excellent Excel advice received in here some time ago, I'm hoping someone can help me with this ☺️ Previous advice showed me how to cause one cell to display a '1' if another named cell contained a number greater than zero, e.g: =IF(A1>0,1"") I need to do something similar, but this time I need the '1' to be displayed if the named cell is NOT BLANK. For example, if I type any value into cell A1, a '1' will appear in cell B1 Further to the screenshots above, the =IF(W7>0,1"") formula (copied down column X) correctly inserts a '1' into the 'Days Operated' fields, but typing '0' does not (I type a zero in the 'Service Users' column if no passengers are travelling but the service is still operating). Ideally, with the correct formulae in place, the example above would look like this: Thanks in advance ? Link to comment Share on other sites More sharing options...
Kurre Posted September 24, 2020 Share Posted September 24, 2020 I'm not sure but have read up on some basics earlier in life. I think it needs, >= ,Greater-Than or Equal To. Iow, add the equal sign to your greater than sign. 1 Link to comment Share on other sites More sharing options...
Des Adam Posted September 24, 2020 Share Posted September 24, 2020 (edited) Hi Steve, Try this formula =IF(ISBLANK(A1),"",1) Hopefully it does what you want Edited September 24, 2020 by Des Adam 1 1 Link to comment Share on other sites More sharing options...
craigb Posted September 24, 2020 Share Posted September 24, 2020 My friends say that when I die, my eulogy will be done in Excel since my entire life seems to revolve around it (you have no idea how many weird things I've done using Excel instead of, possibly, more appropriate tools - LOL!). Anyway, Kurre's solution won't work because when cells are formatted as a number then no value is treated as zero (so every cell will become one whether you type a 0 in the cell or not). However, Des' solution will work for ya! If you have any other Excel questions, feel free to PM me. ? 1 1 Link to comment Share on other sites More sharing options...
antler Posted September 24, 2020 Share Posted September 24, 2020 (edited) How about an Excel Drum Machine? (no, that isn't my video) Edited September 24, 2020 by antler 1 Link to comment Share on other sites More sharing options...
Bapu Posted September 24, 2020 Share Posted September 24, 2020 They all sound better than my programmed drums ? 1 Link to comment Share on other sites More sharing options...
paulo Posted September 24, 2020 Share Posted September 24, 2020 Just what this forum needed.........yet another copycat fred title......? Well done. ? 2 Link to comment Share on other sites More sharing options...
Bapu Posted September 24, 2020 Share Posted September 24, 2020 (edited) ?He must be proud of hisownself? Edited September 24, 2020 by Bapu 1 Link to comment Share on other sites More sharing options...
Bapu Posted September 24, 2020 Share Posted September 24, 2020 I was gonna suggest =IF(ISBBAPU(A1),"Unfunny","Hilarious"), but thought better of it. 1 Link to comment Share on other sites More sharing options...
craigb Posted September 24, 2020 Share Posted September 24, 2020 =IF(K1="Am",PlayBapu(),TwatUpToAm()) ? 1 1 Link to comment Share on other sites More sharing options...
SteveStrummerUK Posted September 24, 2020 Author Share Posted September 24, 2020 7 hours ago, Kurre said: I'm not sure but have read up on some basics earlier in life. I think it needs, >= ,Greater-Than or Equal To. Iow, add the equal sign to your greater than sign. Thanks for your input Kurre. I did actually come up with this myself ? Unfortunately, as I quickly discovered, this formula treats an empty cell and a cell with a zero in it exactly the same. Link to comment Share on other sites More sharing options...
SteveStrummerUK Posted September 24, 2020 Author Share Posted September 24, 2020 7 hours ago, Des Adam said: Hi Steve, Try this formula =IF(ISBLANK(A1),"",1) Hopefully it does what you want Absolutely nailed it Des! Thank you so much for your help ? Link to comment Share on other sites More sharing options...
SteveStrummerUK Posted September 24, 2020 Author Share Posted September 24, 2020 2 hours ago, craigb said: If you have any other Excel questions, feel free to PM me. Thanks mate. My problems figuring out (no punishment in ten did) Excel arise because I was a really late starter, so I've never learned it from the ground up. I stumbled into using it as a slightly more useful tool than Word Tables. Hence every time I 'need' a new feature, it's a Google search or seeking help in here ? I use it at work for basic ready-reckoning of cash in/out, and for recording/manipulating stats (as per the example I sought advice on in the OP). I'm much the same bumbling around in Photoshop - I know all the basics but if I need to delve deeper into some technique or feature, it usually entails a trip to Google or YouTube to find the answer. Rest assured I most definitely will be taking you up on your kind offer of some Excellent advice before too long ? Link to comment Share on other sites More sharing options...
SteveStrummerUK Posted September 24, 2020 Author Share Posted September 24, 2020 1 hour ago, paulo said: Just what this forum needed.........yet another copycat fred title......? Well done. ? Harrumph etc ? I appear to be have been well and truly hoist by my own petard ? Link to comment Share on other sites More sharing options...
SteveStrummerUK Posted September 24, 2020 Author Share Posted September 24, 2020 1 hour ago, Bapu said: I was gonna suggest =IF(ISBBAPU(A1),"Unfunny","Hilarious"), but thought better of it. I much prefer: =IF(ISBBAPU(Am),"Unfunny","Hilarious") ? 1 Link to comment Share on other sites More sharing options...
Bapu Posted September 24, 2020 Share Posted September 24, 2020 1 hour ago, SteveStrummerUK said: I much prefer: =IF(ISBBAPU(Am),"Unfunny","Hilarious") ? As there could be a cell Am (39 cells to the right), That is quite apropos. Well Done! 1 Link to comment Share on other sites More sharing options...
craigb Posted September 25, 2020 Share Posted September 25, 2020 1 hour ago, Bapu said: As there could be a cell Am (39 cells to the right), That is quite apropos. Well Done! Bapu's favorite cell is probably AM440, ya? ? Link to comment Share on other sites More sharing options...
Des Adam Posted September 25, 2020 Share Posted September 25, 2020 9 hours ago, SteveStrummerUK said: Absolutely nailed it Des! Thank you so much for your help ? No worries Steve. If you need any other excelly type help just pm me. 1 Link to comment Share on other sites More sharing options...
57Gregy Posted September 25, 2020 Share Posted September 25, 2020 22 hours ago, SteveStrummerUK said: manipulating stats Gone into politics, Steve? ? 1 Link to comment Share on other sites More sharing options...
paulo Posted September 26, 2020 Share Posted September 26, 2020 On 9/24/2020 at 10:31 PM, SteveStrummerUK said: I appear to be have been well and truly hoist by my own petard Bill, the nervous javelin thrower, is in the house! 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now