Dear Friends,
I create a formula to got automatic number with the currency but total amount is error.
Please help to advise what formula I needed to got result in column G and I in attached file.
Thank you in advance for your help.
Best regards,
Wie Wie
Put this formula in G3:
=F3&" "& TEXT(D3*E3,"#,###.00")
then copy down. Use this formula in I3:
=H3*SUBSTITUTE(G3,F3&" ","")
then copy that down.
Hope this helps.
Pete
Try
I3=TRIM(RIGHT(SUBSTITUTE(G3," ",REPT(" ",50)),50))*H3 and drag down.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Dear Pete and Ankur,
That work, thank you so much for your help
have a nice day
Best regards,
Wie Wie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks