the code now is
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...
=IF(G17>40, (G18*V22)+(G13*O22),G13*O22)
is there something similar to this?=IF G13>0,(=IF(G17>40, (G18*V22)+(G13*O22),G13*O22),0
Last edited by Bajungadustin; 05-27-2011 at 04:10 PM.
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.Originally Posted by Bajungadustin
dang.. nevermind.. i forgot to move the boxes after i filled it down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks