IF Statement help, Triple nested -

IF Statement help, Triple nested -

i'm looking homecoming value of 0 if cell c47 has value @ or below 0, maintain getting homecoming of negative value of cell e9. other calculations in formula work great. can't figure out i'm doing wrong. i'm new nested if statements.

=if(c47>0,(if(c47>$c$3*.8,d47-(f47+$e$9),if(c47>1,d47-(f47+(sum($e$6:$e$8))),))))

all help appreciated. give thanks you.

you need have c47<=1 somewhere in equation, every reference c47 beingness greater value, never beingness less value. nesting doesn't follow use. i'm not sure of goal can lay out similar illustration may help some:

= if(c47>1, "more 1",if(c47>0,"more 0",if(c47<=0,"less zero","")))

hope helps some. think 1 time move ifs around little easier help it.

if-statement nested-if