| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with script. Join values in helper column and run routine. | Excel Programming | |||
| Join text and 2 dates in A2 column in worksheet | Excel Programming | |||
| How to join two functions in a formula? | Excel Worksheet Functions | |||
| how do I join month(#) in col a and day(#) in column b to a date? | Excel Discussion (Misc queries) | |||
Linear Mode
