Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Conditional calculations Conditional calculations
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-30-2017, 08:24 AM
LearnerExcel LearnerExcel is offline Conditional calculations Windows 7 32bit Conditional calculations Office 2003
Advanced Beginner
Conditional calculations 		 
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default Conditional calculations
How can I write a conditional SUM formula to get these totals.



If A2 has some value then it should SUM the values as =SUM(A2*C2) if A2 has "0" then
it should calculate SUM as =SUM(B2*C2).

What is the code for this one, please.
Attached Images
File Type: png If Calculation.PNG (5.9 KB, 27 views)
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculations etobias Word 2 11-09-2016 10:14 AM
Calculations etobias Word 1 01-08-2016 01:50 PM
Conditional calculations Calculations etobias Word 4 12-03-2015 01:36 PM
Conditional calculations Table Calculations, VBA SuzeG Word VBA 7 12-15-2013 07:12 PM
How to do Calculations In a Text Box? SteveF Word 4 09-27-2013 08:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:09 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft