# Search:

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

Page 1 of 6 1

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

by leopardhawk
Replies
3
Views
54

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

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

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

by leopardhawk
Replies
3
Views
54

### 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...

by leopardhawk
Replies
13
Views
369

### Re: Need help with IF statement

Perfect! Thank you so much!

Cheers!

by leopardhawk
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)}

by leopardhawk
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...

by leopardhawk
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...

by leopardhawk
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!

by leopardhawk
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...

by leopardhawk
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. ## Thread: Need help with AVERAGEIF formula

by leopardhawk
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. ## Thread: Need help with AVERAGEIF formula

by leopardhawk
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. ## Thread: Need help with AVERAGEIF formula

by leopardhawk
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. ## Thread: need help with DATEIF formula

by leopardhawk
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. ## Thread: need help with DATEIF formula

by leopardhawk
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. ## Thread: need help with DATEIF formula

by leopardhawk
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. ## Thread: need help with DATEIF formula

by leopardhawk
Replies
8
Views
294

### Re: need help with DATEIF formula

Thank you so much! Works perfectly now.

Cheers!
17. ## Thread: need help with DATEIF formula

by leopardhawk
Replies
8
Views
294

### Re: need help with DATEIF formula

sorry, I meant to say DATEDIF...
18. ## Thread: need help with DATEIF formula

by leopardhawk
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. ## Thread: Can't understand why two values are different

by leopardhawk
Replies
6
Views
223

### 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. ## Thread: Can't understand why two values are different

by leopardhawk
Replies
6
Views
223

### 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. ## Thread: Custom data validation

by leopardhawk
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. ## Thread: Formula relating to a date of birth and a retirement date

by leopardhawk
Replies
3
Views
201

### 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. ## Thread: Custom data validation

by leopardhawk
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. ## Thread: Formula relating to a date of birth and a retirement date

by leopardhawk
Replies
3
Views
201

### 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. ## Thread: Custom data validation

by leopardhawk
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