Question about Business & Productivity Software
I am constructing a Sales Order form and I'm having trouble with a formula. In column E the user will enter a value. From that value I need to create the pricing based on a value in column B. If the value in E is less than or equal to 37, then multiply the value in B by 14.3, If E is greater than 37 but less than or equal to 43, then multiply the value in B by 15.05, and, if E is greater than 43 but less than or equal to 49, then multiply the value in B by 15.8. If greater than 49 then return no value.
Give me all excel formulas
Posted on Feb 18, 2008
=IF((E2<38),B2*14.3, IF((E2<44),B2*15.05, IF((E2<50),B2*15.8,0)))
Note that <38 is the same as <=37. Also, you can replace the 0 at the end with empty quotes "" for a blank cell.
Posted on Dec 04, 2007
Tips for a great answer:
Mar 06, 2015 | Microsoft Excel 2010
Apr 02, 2008 | Business & Productivity Software
Nov 05, 2009 | Microsoft Office Excel 2003 for PC
Mar 11, 2009 | Microsoft Office Excel 2003 for PC
Jan 05, 2009 | Microsoft Business & Productivity Software
Dec 21, 2008 | Microsoft Excel for PC
Sep 30, 2008 | Microsoft Excel for PC
Jul 08, 2008 | Microsoft Business & Productivity Software
Nov 13, 2007 | Business & Productivity Software
Sep 11, 2007 | Microsoft Office Standard for PC
Oct 21, 2016 | The Business & Productivity Software
135 people viewed this question
Usually answered in minutes!