Question about Computers & Internet
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
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Sep 19, 2017 | Excel Computers & Internet
Mar 06, 2015 | Microsoft Excel 2010
Nov 05, 2009 | Microsoft Office Excel 2003 for PC
Mar 11, 2009 | Microsoft Office Excel 2003 for PC
Dec 21, 2008 | Microsoft Excel for PC
Sep 30, 2008 | Microsoft Excel for PC
Jul 08, 2008 | Microsoft Computers & Internet
Apr 02, 2008 | Computers & Internet
Nov 13, 2007 | Computers & Internet
Sep 11, 2007 | Microsoft Office Standard for PC
Sep 20, 2018 | Mercury Computers & Internet
150 people viewed this question
Usually answered in minutes!