Can i add an IF inside of an IF? (nested?)

[Bajungadustin]

the code now is

Please Login or Register  to view this content.

the problem is all the math that is involved is adding numbers when it needs to not be counted. for example in this code G13 is my user input and it is 0 however it returns a result of 6 and i need it to be 0 if no data is entered into G13... soo...

Please Login or Register  to view this content.

is there something similar to this?

[Bajungadustin]

got it myself :P

=IF(G13>0,IF(G17>40, (G18*V22)+(G13*O22),G13*O22),0)

[Bajungadustin]

got it myself :P

=IF(G13>0,IF(G17>40, (G18*V22)+(G13*O22),G13*O22),0)

nope im wrong. if i do this it alters the output for those areas WITH user entered data.

[Bajungadustin]

dang.. nevermind.. i forgot to move the boxes after i filled it down.