| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Function
I am having trouble using the if function. I am trying to
have a cell(J4) return either the value of defined name (newteamcost) or (old teamcost) depending on whether the value in (b4) is O or N (Capital O or Capital N). Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Function
Tom
From your wording, I take it, that lower case o or n are not allowed. If this holds, here's one way to do it: In J4: =IF(EXACT(B4,"O"),newteamcost,IF(EXACT(B4,"N"),old teamcost,"")) -- Best Regards Leo Heuser Followup to newsgroup only please. "Tom Donino" skrev i en meddelelse ... I am having trouble using the if function. I am trying to have a cell(J4) return either the value of defined name (newteamcost) or (old teamcost) depending on whether the value in (b4) is O or N (Capital O or Capital N). Any help would be appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Function
Thanks for the reply but that is not working. I also
tried removing the (EXACT portion of eac and the end parentheses but that is not working either. -----Original Message----- Tom From your wording, I take it, that lower case o or n are not allowed. If this holds, here's one way to do it: In J4: =IF(EXACT(B4,"O"),newteamcost,IF(EXACT (B4,"N"),oldteamcost,"")) -- Best Regards Leo Heuser Followup to newsgroup only please. "Tom Donino" skrev i en meddelelse ... I am having trouble using the if function. I am trying to have a cell(J4) return either the value of defined name (newteamcost) or (old teamcost) depending on whether the value in (b4) is O or N (Capital O or Capital N). Any help would be appreciated. . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Function
What is not working?
Please specify. What happens, when you enter the formula? LeoH skrev i en meddelelse ... Thanks for the reply but that is not working. I also tried removing the (EXACT portion of eac and the end parentheses but that is not working either. -----Original Message----- Tom From your wording, I take it, that lower case o or n are not allowed. If this holds, here's one way to do it: In J4: =IF(EXACT(B4,"O"),newteamcost,IF(EXACT (B4,"N"),oldteamcost,"")) -- Best Regards Leo Heuser Followup to newsgroup only please. "Tom Donino" skrev i en meddelelse ... I am having trouble using the if function. I am trying to have a cell(J4) return either the value of defined name (newteamcost) or (old teamcost) depending on whether the value in (b4) is O or N (Capital O or Capital N). Any help would be appreciated. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
Hybrid Mode
