Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 03-09-2010, 11:23 AM
brians brians is offline If A1 greater than or equal to 1 Then A3 = A2*A1 Windows XP If A1 greater than or equal to 1 Then A3 = A2*A1 Office 2007
Novice
If A1 greater than or equal to 1 Then A3 = A2*A1
 
Join Date: Mar 2010
Posts: 3
brians is on a distinguished road
Default

Imagine 3 columns. Cell A1 reads the quantity, Cell B1 reads the Cost and cell C1 reads the Total. Cell A2 has a number 1 in it. Cell B2 has $10.00 in it and Cell C2 should then have $10.00 in it. If I change Cell A2 (the quantity) to 8, then Cell C2 should change to $80.00. Conversely if have Cell A2 be 1, Cell B2 to read $20.00 Cell C2 should be $20.00.

A B C
1 1 $10 10

A B C
1 2 $10 20

A B C
1 8 $15 120

I hope this clears it up.
Reply With Quote
 



Other Forums: Access Forums

All times are GMT -7. The time now is 02:30 AM.


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