Question about Microsoft EXCEL 2004 for Mac

1 Answer

BEST WAY TO SET UP IF/OR FUNCTION IN EXCEL FOR MAC 2004

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

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    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

6ya6ya
  • 2 Answers

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

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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

How to change permission to use my Excel 2011


Restrict permission to content in a file - Office Support

https://support.office.com/.../Restrict-permission-to-content-in-a-file-3cd...
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

https://support.office.com/...my/.../Restricting-changes-by-using-readonl...
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

7 Answers

How to repair damage excel file


Use Excel Repair Toolbox designed to restore data from corrupted .XLS files. MS Office .XLS file repair software can fix many error.
For more: https://www.xlsrepairtoolbox.com/

Jul 14, 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.

Nilesh

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 it....so another option...assuming you can't do that in Mac would be to export it to Windows....do 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

82 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18385 Answers

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

Answer questions

Manuals & User Guides

Loading...