Join two functions to one column

G

Greg

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
 
R

Rick Rothstein

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),""))
 
G

Greg

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recorded macro selection widened 4
Menu Macro Not Executing - Need Help 1
Chart should read as blank cell not as 0,it shows blank but reads 1
Removal of Zero 4
column loop 3
Modify working code to expand the output. 5
Multi-Conditional IF Statements 3
Error message needed if incorrect Date Of Birth (DOB) entered 5

Top