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.

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.

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.

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.