| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF function
I have the following formula for range of rows in Column F - I want the cell
populated by 1. meeting first condition (formula below) 2. looking at Column D and returning value in Column F instead of "null" if cell (row) is populated Column D Cell F13 has formula =IF(AND(J17=81.73),0.12,IF(AND(J17=81.73),0)) I had help with this first formula; I really need help now with the second. -- The generosity of your knowledge is greatly appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested IF function
One guess, maybe you had this in mind ..
F13 has formula =IF(AND(J17=81.73),0.12,IF(AND(J17=81.73),0)) In F13, make it as just: =IF(J17=81.73,0.12,0) Then in say, G13: =IF(D13<"",F13,"") Or if you want it combined (do away with F13), just use this in G13: =IF(D13<"",IF(J17=81.73,0.12,0),"") -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "mrl" wrote: I have the following formula for range of rows in Column F - I want the cell populated by 1. meeting first condition (formula below) 2. looking at Column D and returning value in Column F instead of "null" if cell (row) is populated Column D Cell F13 has formula =IF(AND(J17=81.73),0.12,IF(AND(J17=81.73),0)) I had help with this first formula; I really need help now with the second. -- The generosity of your knowledge is greatly appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested IF function
Thank you for trying Max - I was not clear in my first post. I will post
again, with better explanation. -- The generosity of your knowledge is greatly appreciated. "Max" wrote: One guess, maybe you had this in mind .. F13 has formula =IF(AND(J17=81.73),0.12,IF(AND(J17=81.73),0)) In F13, make it as just: =IF(J17=81.73,0.12,0) Then in say, G13: =IF(D13<"",F13,"") Or if you want it combined (do away with F13), just use this in G13: =IF(D13<"",IF(J17=81.73,0.12,0),"") -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "mrl" wrote: I have the following formula for range of rows in Column F - I want the cell populated by 1. meeting first condition (formula below) 2. looking at Column D and returning value in Column F instead of "null" if cell (row) is populated Column D Cell F13 has formula =IF(AND(J17=81.73),0.12,IF(AND(J17=81.73),0)) I had help with this first formula; I really need help now with the second. -- The generosity of your knowledge is greatly appreciated. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested IF function
No prob.
Take a moment to press "Yes" button from where you're reading this -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "mrl" wrote: Thank you for trying Max - I was not clear in my first post. I will post again, with better explanation. -- The generosity of your knowledge is greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF function??? | Excel Worksheet Functions | |||
| Nested And function | Excel Worksheet Functions | |||
| can you nested sum and round function within if function? | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
