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
A 6ya expert can help you resolve that 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.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Sep 19, 2017 | Excel Computers & Internet
Apr 02, 2008 | 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
Nov 13, 2007 | Computers & Internet
Sep 11, 2007 | Microsoft Office Standard for PC
150 people viewed this question
Usually answered in minutes!