Is there a faster, easier way to calculate this...It's a bit baffling??!!
Simply place an = in front of the formula to get the just of it!
Formula Challenge...
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Formula Challenge...
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78494
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Formula Challenge...
See the attached version:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Formula Challenge...
Wow..that certainly brings a bit more simplicity to the process. I received this formula from someone and spend 10 minutes trying to step through the formula to just make sense of it, let alone fix the error it posed. Your helper 'rows' really make it quite simple now!
Many TX Double
Many TX Double
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.