Hello faist001, I'm a visualize person, thus forgive me if I'm wrong. Try the code below.
![]()
=IF(B3>0,(C3-B3)/B3,IF(C3>0,C3-(C3-0.1)/(C3*99),IF(OR(B3=0, C3=0), 0, "Formula Incomplete")))
Hello faist001, I'm a visualize person, thus forgive me if I'm wrong. Try the code below.
![]()
=IF(B3>0,(C3-B3)/B3,IF(C3>0,C3-(C3-0.1)/(C3*99),IF(OR(B3=0, C3=0), 0, "Formula Incomplete")))
Last edited by dluhut; 02-13-2013 at 02:13 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks