Question about Microsoft EXCEL 2004 for Mac

1 Answer


I made the following work -- By trial and error -- Why should it be so hard to solve such a simple problem =IF(OR(F7="",H7=""),"",(H7-F7))

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.

Posted by on


1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert whose answer got voted for 20 times.


    An expert who has answered 20 questions.

  • Expert
  • 67 Answers

Formula :
=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


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

2 Answers

How to change permission to use my Excel 2011

Restrict permission to content in a file - Office Support
My accountSign in ... Which Office program are you using? Word. PowerPoint. Excel... to content in a file, you have to have Microsoft Office for Mac Standard 2011. ... Authors can use the Set Permissions dialog box to set expiration dates for ...

Restricting changes by using read-only status - Office Support
My accountSign in ... Which Office program are you using? Word. PowerPoint. Excel... only the owner or those with Write privileges can remove the designation. ... Applies To: PowerPoint for Mac 2011, Word for Mac 2011, Excel for Mac 2011.

Jan 05, 2016 | Microsoft Excel for Mac 2011 D46-00803

4 Answers

Cannot open file. Error message reads: Excel cannot open

Use Excel Repair Toolbox is efficient corrupt XLSX file repair software, suitable for all data recovery activities, applied to Microsoft Excel documents.

For more:

Aug 03, 2015 | Microsoft Excel for PC

1 Answer

The product of two 2-digit numbers is 1938. If the product of their unit's digit is 28 and that of their ten's digit is 15, find the numbers.

For solving this type of problem trial and error method is easy.We can solve this problem using trial and error method.

There are two two digits number.Product of their units place is 28,which means only possibility is 7 and 4

Now product of tens place number is 15.Possibility is 3 and 5

so numbers can be 37,54 or 57,34.

By multiplying these numbers we can see that our required solution is 57 and 34

May 21, 2010 | Vivendi Excel@ Mathematics Study Skills...

4 Answers

Using excel to solve problem by trial and error method

In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.


Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

2 Answers

"unable to read file" message when opening an Excel workbook.

I was sent an excel file (.xls). friends on mac and pc can both open it.

i am on mac and keep getting unable to read error. it must be something with my mac. what could it be? nobody else has this problem.

Jan 03, 2009 | Microsoft EXCEL 2004 for Mac

2 Answers

Excel fromula

You may want to learn the use of function "INDIRECT", so you can construct your formular refer to variables in certain cells.

May 31, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Excel2004 MAC

Not familiar with Mac but if you simply copy it (the data)and paste to a new spreadsheet that might work. In windows you can unprotect another option...assuming you can't do that in Mac would be to export it to it and the send it back to Mac. Suggest you check your help dialogues as well...should not be an insurmountable problem. Hope this helps...Tango.

Feb 05, 2008 | Microsoft EXCEL 2004 for Mac

Not finding what you are looking for?
Microsoft EXCEL 2004 for Mac Logo

85 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2983 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides