=IF(E5<=36,E5-7,"")=IF(E5>36,E5-9,"")
Hi,
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.
Good luck!
Posted on Jan 02, 2017
Sep 16, 2014 | Microsoft Excel for PC
Jan 09, 2013 | Microsoft Excel Computers & Internet
Jun 23, 2011 | Microsoft Excel for PC
Nov 29, 2010 | Microsoft Office Excel 2003 for PC
Mar 06, 2009 | Microsoft Office Excel 2003 for PC
Dec 15, 2008 | Microsoft Windows XP Home Edition
Nov 24, 2008 | Microsoft Office 2003 Basic Edition...
Oct 10, 2008 | Microsoft Excel for PC
Mar 02, 2008 | Microsoft Windows XP Home Edition
Oct 03, 2007 | Microsoft Office Standard for PC
95 people viewed this question
Usually answered in minutes!
I still had a problem with the solution as a negative number is viewable before I enter a number, so I came up with this and was wondering if there was a shorter version?
=IF(E5<28,"",IF(E5<45,E5-7,IF(E5>44.5,E5-9)))
×