Hello,i need to put the Ndoc (first row) twice if it has a value in both columns (ICMS, IPI) if the value is 0 in any of these rows then it just needs to type Ndoc once.
i tried this but it doesnt check if is ICMS or IPI
i dont know which function i should be using
Please Login or Register to view this content.
Thx in advance
Welcome to the forum.
At the top of this page there are instructions about how to attach your workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
My bad, thank you for the welcome
Can you attach a copy of your file which shows the expected results in sheet "BDC"?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks