Hi all,
Hope u guys doing well. I am making an Invoice. where i need to input data based on PCS. Please help me to find out the solution. it would be highly appreciated.
NEED A FORMULA IN THE YELLOW CELL LIKE, IF B8 CONTAINS TEXT (5PCS/PACK), THEN F10 WILL BE MULTIPLIED BY F6 CELL*5, AND IF B8 CELL CONTAIN (3 PCS/PACK), THEN F10 WILL BE CALCULATED BY F6*3
Attaching file.
Bookmarks