Question about Microsoft EXCEL 2004 for Mac

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

• 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

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

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).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

Related Questions:

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

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

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: https://www.xlsxrepairtoolbox.com/

Aug 03, 2015 | Microsoft Excel for PC

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

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

"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

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

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

Open Questions:

Related Topics:

85 people viewed this question

Level 3 Expert

Level 3 Expert