Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-09-2010, 10:36 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 If A1 greater than or equal to 1 Then A3 = A2*A1


I need to know how to format a cell so that if for example:

If
A1 greater than or equal to 1
Then
A3 = A2*# from A1

Basically I have:
A1 Qty
A2 Cost
A3 Total

If A1 (qty) is greater or less than 1
Then A3 (total) needs to = A1 (qty) x A2 (cost)

Any help would be great. I know basics but conditional formatting is a little beyond me.
Reply With Quote
 



Other Forums: Access Forums

All times are GMT -7. The time now is 12:52 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