Is this do you mean??
=IF(LEFT(A1)="<","<","")&TEXT(SUBSTITUTE(A1,"<","")*B1*8.34,"[<10]0.0;-0;0")
Is this do you mean??
=IF(LEFT(A1)="<","<","")&TEXT(SUBSTITUTE(A1,"<","")*B1*8.34,"[<10]0.0;-0;0")
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks