Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 08-27-2011, 03:26 AM
Catalin.B Catalin.B is offline VBA Macro computational Windows Vista VBA Macro computational Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

try this formula: (replace red values as necessary) same formula in sample attached)
how many combinations can be in Columns C and D?
If there are too many, we need another approach...
=IF(AND(C2="Xerox";D2="Short")=TRUE;B2*2;IF(AND(C2="Print";D2="Short")=TRUE;B2*3;IF(AND(C2="Xerox";D2="Long")=TRUE;B2*5;IF(AND(C2="Print";D2="Long")=TRUE;B2*4;""))))
Attached Files
File Type: xls Book1.xls (20.5 KB, 9 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I assign a macro to a button when the macro is in my personal workbook? foolios Excel Programming 2 07-27-2011 02:41 PM

Other Forums: Access Forums

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