Hello,
I am having an issue with an Nested IF THEN statement. I am hoping you can assist.
The formula i have is located in DR4
`=IF(DF4="0","",IF(R4="PC",((S4+1.5)*(T4+1.5)*(U4+1.5)-(S4*T4*U4)),((S4+1.5)*(T4+1.5)*(U4+1.5)-(S4*T4*U4))*V4)/1728*7.48)
the goal is to look at DF4 if its zero then DR4 is zero
if its any other number than 0 apply the balance of the formula.
thank you in advance for your assistance. Please see sample spreadsheet for your consideration.
https://www.dropbox.com/s/136nk8e6qh5ddb8/nested if then question 7.15.18.xlsx?dl=0
Jason
I am having an issue with an Nested IF THEN statement. I am hoping you can assist.
The formula i have is located in DR4
`=IF(DF4="0","",IF(R4="PC",((S4+1.5)*(T4+1.5)*(U4+1.5)-(S4*T4*U4)),((S4+1.5)*(T4+1.5)*(U4+1.5)-(S4*T4*U4))*V4)/1728*7.48)
the goal is to look at DF4 if its zero then DR4 is zero
if its any other number than 0 apply the balance of the formula.
thank you in advance for your assistance. Please see sample spreadsheet for your consideration.
https://www.dropbox.com/s/136nk8e6qh5ddb8/nested if then question 7.15.18.xlsx?dl=0
Jason
