|
Forums59
Topics1,039,986
Posts13,973,631
Members144,227
| |
Most Online39,925
Dec 30th, 2023
|
|
 Re: Need an excel guru please
[Re: Bigbob_FTW]
#12488274
11/01/17 11:53 PM
|
Joined: Jun 2005
Posts: 33,275
lanman71
Maroon!
|
|
Maroon!
Joined: Jun 2005
Posts: 33,275 |
What a maroon!
|
|
|
Re: Need an excel guru please
[Re: joebass2]
#12488275
11/01/17 11:54 PM
|
Joined: Jun 2005
Posts: 33,275
lanman71
Maroon!
|
|
Maroon!
Joined: Jun 2005
Posts: 33,275 |
=IF(DP=0,,IF(Type="AGMA Stub",0.8/normDP,IF(Type="Fellows Stub",1/SP,1/normDP)))
_________________________
IF DP=0 and Type='AGMA Stub', value = 0.8/normDP
IF DP=0 and Type='Fellows Stub', value=1/Sp
IF DP<>0 , value=1/normDP
#excelstrong
What a maroon!
|
|
|
Re: Need an excel guru please
[Re: lanman71]
#12488886
11/02/17 12:46 PM
|
Joined: Feb 2004
Posts: 2,051
Catfish_Hunter
Extreme Angler
|
|
Extreme Angler
Joined: Feb 2004
Posts: 2,051 |
=IF(DP=0,,IF(Type="AGMA Stub",0.8/normDP,IF(Type="Fellows Stub",1/SP,1/normDP)))
_________________________
IF DP=0 and Type='AGMA Stub', value = 0.8/normDP
IF DP=0 and Type='Fellows Stub', value=1/Sp
IF DP<>0 , value=1/normDP
#excelstrong Actually...it's IF DP=0 , output = TRUE IF DP<>0 and Type='AGMA Stub', value = 0.8/normDP IF DP<>0 and Type='Fellows Stub', value=1/Sp IF DP <>0 and Type <> 'AGMA Stub' and Type <> 'Fellow Stub', output = 1/normDP
No fish is too good for the grease.
|
|
|
Re: Need an excel guru please
[Re: Bigbob_FTW]
#12488963
11/02/17 01:36 PM
|
Joined: Sep 2006
Posts: 12,450
JIM SR.
TFF Guru
|
|
TFF Guru
Joined: Sep 2006
Posts: 12,450 |
and I thought green pumpkin was the answer to everything on here,.. 
|
|
|
Re: Need an excel guru please
[Re: Bigbob_FTW]
#12489009
11/02/17 01:59 PM
|
Joined: Oct 2006
Posts: 95,844
Bigbob_FTW
OP
Big Sprocket Bob
|
|
OP
Big Sprocket Bob
Joined: Oct 2006
Posts: 95,844 |
I had to go back to the original author. Even he is struggling with it (wrote it many years ago). I'll post the results.
![[Linked Image]](https://texasfishingforum.com/forums/pics/usergals/2017/07/full-20284-169975-biyl8lail.jpg) ![[Linked Image]](https://texasfishingforum.com/forums/pics/usergals/2017/07/full-20284-169974-image_preview.jpg) FJB
|
|
Moderated by banker-always fishing, chickenman, Derek 🐝, Duck_Hunter, Fish Killer, J-2, Jacob, Jons3825, JustWingem, Nocona Brian, Toon-Troller, Uncle Zeek, Weekender1
|
