User Profile
michellehit-incnet
Copper Contributor
Joined Dec 19, 2022
User Widgets
Recent Discussions
formula help
Hi Everyone, I'm looking for the right formula here. In one column I have the product type which is either Diesel or Def. In another column, I have the number of gallons used for that product. And in separate cells for the "constants" there is the price of Diesel and the price of Def. So I need the formula to be like: IF Column A1 equals "Diesel" (the product), multiply Column B1 (# gallons) by constant Cell C (price per gallon). so that I can have it calculate the price for me and then add up the totals for each Diesel and Def. Thank you in adv775Views0likes1Comment
Recent Blog Articles
No content to show