| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple IF functions, different ranges
Here is the scenario
Calculating the difference in times =IF(G17="",H17-E17,(H17-E17)-(G17-F17)) I want to be able to add a 2nd function that would cancel this request if J17= "Reject" Can this be done utilizing an OR function or a 2nd IF function? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple IF functions, different ranges
I'm not exactly certain what you mean by "cancel this request". If you mean
to return nothing when J17="Reject" then: =IF(J17="Reject","",IF(G17="",H17-E17,(H17-E17)-(G17-F17))) Tyro "Scott Kieta" wrote in message ... Here is the scenario Calculating the difference in times =IF(G17="",H17-E17,(H17-E17)-(G17-F17)) I want to be able to add a 2nd function that would cancel this request if J17= "Reject" Can this be done utilizing an OR function or a 2nd IF function? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple IF functions, different ranges
That is exactly what i meant, this works for me.
Thanks "Tyro" wrote: I'm not exactly certain what you mean by "cancel this request". If you mean to return nothing when J17="Reject" then: =IF(J17="Reject","",IF(G17="",H17-E17,(H17-E17)-(G17-F17))) Tyro "Scott Kieta" wrote in message ... Here is the scenario Calculating the difference in times =IF(G17="",H17-E17,(H17-E17)-(G17-F17)) I want to be able to add a 2nd function that would cancel this request if J17= "Reject" Can this be done utilizing an OR function or a 2nd IF function? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If functions Looking at ranges | Excel Discussion (Misc queries) | |||
| IF functions and Names Ranges | Excel Discussion (Misc queries) | |||
| Copy and SUM functions with different ranges | Excel Worksheet Functions | |||
| Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
| if functions with more than 7 ifs (ranges are possible?) | Excel Worksheet Functions | |||
![Scott Kieta[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
