{"id":8928,"date":"2021-11-30T10:14:16","date_gmt":"2021-11-30T10:14:16","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=8928"},"modified":"2021-11-30T10:14:42","modified_gmt":"2021-11-30T10:14:42","slug":"how-to-do-this-calculation","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/how-to-do-this-calculation\/20919.html","title":{"rendered":"How To Do This Calculation"},"content":{"rendered":"<p>i am trying to do a series of calculation i need to add dollar amounts in d5 cents in e5 then h5 dollar i5 cents then minus j5 dollar k5 cents add l5 dollar m5 cents minus n5 dollar o5 cents all formulated to total in p5 dollars q5 cents<\/p>\n<p>i have the adding side of it working with this formula<\/p>\n<p>=sum(d5,h5,l5)+int(sum(e5,i5,m5)\/100 put in th dollar amount cells and<br \/>\n=right(sum(e5,i5,m5),2)*1 put in the cent cells<\/p>\n<p>but i dont know how to minus j5 dollars k5 cents and n5 dollars o5<br \/>\nall this calculated to p5 dollar amounts q5 cents amount<\/p>\n<p>excel 16 mac air<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":6},"question-category":[53],"question_tags":[],"class_list":["post-8928","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/8928","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=8928"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=8928"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=8928"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=8928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}