Search:

Type: Posts; User: leopardhawk; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Need help with complicated IF statement, possible IFS?

    Fantastic, thanks so much for your help! Works perfectly...

    :-)
  2. Need help with complicated IF statement, possible IFS?

    I have a worksheet that will most likely be used by two people (a couple) but could also be used by a 'single' (unmarried) individual.

    I'll try to explain my conundrum. Here goes...

    The...
  3. Replies
    13
    Views
    369

    Re: Need help with IF statement

    Perfect! Thank you so much!

    Cheers!
  4. Replies
    13
    Views
    369

    Re: Need help with IF statement

    Forgot to mention that yes, I did enter the formula as an array formula, using the CTRL+SHIFT+ENTER.


    {=IFERROR(IF(E204:E225<>"",SUM(E204:E225-OFFSET(E204:E225,-1,1))+MAX(F204:F225)),0)}
  5. Replies
    13
    Views
    369

    Re: Need help with IF statement

    Toadstool, one more question. When there is NO data in columns E & F, the formula returns FALSE which is not a big deal but I would like it better if it just showed a 0 (zero). To that end, I added...
  6. Replies
    13
    Views
    369

    Re: Need help with IF statement

    You, my friend, are a genius. This works perfectly and is exactly what I was hoping for...!! Thank you SO much...

    Cheers!

    p.s. many thanks to everyone else as well, I really appreciate it...
  7. Replies
    13
    Views
    369

    Re: Need help with IF statement

    Okay, I didn't really want to add another column for aesthetic reasons and am still hopeful that there is a formula that will do what I am trying to accomplish. Thanks for reaching out!

    Cheers!
  8. Replies
    13
    Views
    369

    Re: Need help with IF statement

    Thanks to everyone who is trying to help me. I appreciate it.

    As usual, I didn't do a very good job of explaining myself and I apologize for that. I have a cell (J227) that is below the sample...
  9. Replies
    13
    Views
    369

    IF statement

    Hello forum friends, okay, here is an interesting one, at least from my perspective. I have been trying to come up with a formula that will look at two columns and return the difference between the...
  10. Replies
    6
    Views
    248

    Re: Need help with AVERAGEIF formula

    Okay, this works... bit convoluted, but it works...


    =('2018'!I257+'2019'!I208+'2020'!I257+'2021'!I257) / (('2018'!I257<>0)+('2019'!I208<>0)+('2020'!I257<>0)+('2021'!I257<>0))

    Cheers!
  11. Replies
    6
    Views
    248

    Re: Need help with AVERAGEIF formula

    DanteAmor, the cells in 2020 and 2021 are blank but it is including them in the AVERAGE, thereby skewing the result. Here are the first two cells, 2018 and 2019. Note also that on the 2019 sheet,...
  12. Replies
    6
    Views
    248

    Need help with AVERAGEIF formula

    Hello forum friends, this formula below is working but it is also including data for 2020 and 2021 which are both currently 'blank'.


    =AVERAGE('2018'!I257,'2019'!I208,'2020'!I257,'2021'!I257)
    ...
  13. Replies
    8
    Views
    294

    Re: need help with DATEIF formula

    Hi Peter, okay, I tried deleting the old file for Forum Tools and downloaded a new one (by the way, I have only been using the previous one since May of this year when I first downloaded it). ...
  14. Replies
    8
    Views
    294

    Re: need help with DATEIF formula

    Hi Peter, thank you so much for that. I'm at work now but as soon as I get home, I will certainly follow up and try to make sure that I have the latest version. Thanks again. Have a great day!
  15. Replies
    8
    Views
    294

    Re: need help with DATEIF formula

    Hi Peter, thank you so much for reaching out about this. It's called "Forum Tools" and I found the link to it on this forum. What's strange is that when I 'preview' the post, it looks perfect and...
  16. Replies
    8
    Views
    294

    Re: need help with DATEIF formula

    Thank you so much! Works perfectly now.

    Cheers!
  17. Replies
    8
    Views
    294

    Re: need help with DATEIF formula

    sorry, I meant to say DATEDIF...
  18. Replies
    8
    Views
    294

    need help with DATEIF formula

    Hello forum friends, I have an issue with the results of a DATEIF formula I am trying to build. I am receiving a result of $161.92 and it should be $50.06, so I am WAY off somewhere. I have...
  19. Re: Can't understand why two values are different

    Many thanks to Fluff, Joe & Sandy! I found that I had an extra row on my worksheet that was blank and therefore messing up the data! Thanks to all for your assistance!

    Cheers!
  20. Can't understand why two values are different

    Hello forum friends, I am testing a workbook to make sure there are no errors and I am having problems figuring out why these two values are different when they should be exactly the same. If anyone...
  21. Replies
    16
    Views
    470

    Re: Custom data validation

    Peter, fantastic! So much easier, I feel bad for having folks suggesting the ISDATE etc. It works perfectly. Anyway, thanks much and all the best!

    Cheers!
  22. Re: Need help with formula relating to a date of birth and a retirement date

    Okay, I found the problem, the second formula had a semicolon (;) instead of a comma (,). It is now working as intended.

    Cheers!
  23. Replies
    16
    Views
    470

    Re: Custom data validation

    As I continue to try and find a solution to this issue, it occurs to me that my original post "Is it possible to have the data validation in a cell NOT permit any entry at all unless there is a valid...
  24. Re: Need help with formula relating to a date of birth and a retirement date

    Thank you so much for your efforts. The first formula and the third seem to work okay but the second one is giving me an error (There's a problem with this formula.) When I copy/paste it into the...
  25. Replies
    16
    Views
    470

    Re: Custom data validation

    Thanks Peter, the cell with the actual date will only accept a valid date so I hope that that solves that problem. My other issues as defined in my previous post are much more of a concern I think....
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4