LinkBack URL
About LinkBacks
This is my function which returns too many functions because of the last IF statement. Anyway to get it all in?
=IF(H2="AY",IF(C2>0,(C2/100)*1,1/(C2*-1)*1*100),IF(H2="HY",IF(F2>0,(F2/100)*1,1/(F2*-1)*1*100),IF(H2="T",0),-1)))
This is my function which returns too many functions because of the last IF statement. Anyway to get it all in?
=IF(H2="AY",IF(C2>0,(C2/100)*1,1/(C2*-1)*1*100),IF(H2="HY",IF(F2>0,(F2/100)*1,1/(F2*-1)*1*100),IF(H2="T",0),-1)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks