Join two functions to one column
 

I have two functions that work proper in separate cells with the proper value
selected.
when i have M selected the M function works fine and the F shows "FALSE"
When i have F selected the F function works fine and the M shows "FALSE"
Here are the two functions:
=IF(B6="M",IF(SUM(D6*3)+E6<$E$2,(D6*3)+E6,$E$2))
=IF(B6="F",IF(SUM(D6*3)+E6<$E$3,(D6*3)+E6,$E$3))
I need these to be in one column and calculate if the "M" is selected or the
"F" is.
I tried different combination's of each but kept getting "FALSE"

Many Thanks in advance.
Greg

Join two functions to one column
 

Does this do what you want...

=IF(B6="M",IF(D6*3+E6<$E$2,(D6*3)+E6,$E$2),IF(B6=" F",IF(D6*3+E6<$E$3,(D6*3)+E6,$E$3),""))

--
Rick (MVP - Excel)


"Greg" wrote in message
...
I have two functions that work proper in separate cells with the proper
value
selected.
when i have M selected the M function works fine and the F shows "FALSE"
When i have F selected the F function works fine and the M shows "FALSE"
Here are the two functions:
=IF(B6="M",IF(SUM(D6*3)+E6<$E$2,(D6*3)+E6,$E$2))
=IF(B6="F",IF(SUM(D6*3)+E6<$E$3,(D6*3)+E6,$E$3))
I need these to be in one column and calculate if the "M" is selected or
the
"F" is.
I tried different combination's of each but kept getting "FALSE"

Many Thanks in advance.
Greg

Join two functions to one column
 

I Really appreciate everything you Guys/Gals do on here to help us amateurs ;)
Thanks Again! works perfect.
Greg

"Rick Rothstein" wrote:

Does this do what you want...

=IF(B6="M",IF(D6*3+E6<$E$2,(D6*3)+E6,$E$2),IF(B6=" F",IF(D6*3+E6<$E$3,(D6*3)+E6,$E$3),""))

--
Rick (MVP - Excel)


"Greg" wrote in message
...
I have two functions that work proper in separate cells with the proper
value
selected.
when i have M selected the M function works fine and the F shows "FALSE"
When i have F selected the F function works fine and the M shows "FALSE"
Here are the two functions:
=IF(B6="M",IF(SUM(D6*3)+E6<$E$2,(D6*3)+E6,$E$2))
=IF(B6="F",IF(SUM(D6*3)+E6<$E$3,(D6*3)+E6,$E$3))
I need these to be in one column and calculate if the "M" is selected or
the
"F" is.
I tried different combination's of each but kept getting "FALSE"

Many Thanks in advance.
Greg

.