Question about Microsoft EXCEL 2004 for Mac
I made the following work -- By trial and error -- Why should it be so hard to solve such a simple problem
If neither F7 or H7 is blank/empty I needed to get the difference between H7 & F7.
I have not been able to find any documentation for setting up such an IF/OR function. Even though it is very useful.
If data is available for both G7 & H7, I compute the difference. Otherwise I shoot a BLANK.
I use this to tally points for the year for NASCAR races. I hate to admit that my sister won last year -- One deluxe dinner in Hilo, Hawaii.
=If (F7<>"", (IF (H7<>"",H7-F7,"")),"")
Sometimes you need to use the opposite comparison, like instead of being equal to "" try to compare it if it's not equal to "". The formula above should work with no problem. Good luck :)
Posted on Feb 24, 2009
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:
Jan 05, 2016 | Microsoft Excel for Mac 2011 D46-00803
Aug 03, 2015 | Microsoft Excel for PC
May 14, 2014 | Computers & Internet
May 21, 2010 | Vivendi Excel@ Mathematics Study Skills...
Apr 23, 2009 | Computers & Internet
Mar 31, 2009 | Microsoft EXCEL 2004 for Mac
Jan 03, 2009 | Microsoft EXCEL 2004 for Mac
Feb 05, 2008 | Microsoft EXCEL 2004 for Mac
81 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: