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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

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

1 Answer

Unable to read the file


probably the file is corrupted.
search in google if there is any program to cure the file or do another think, get this file to another pc/laptop and try if it opens there.

Feb 12, 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

Doubt


Sir..
I have to buy a new version of microsoft excel, word, power point && outlook etc.I want this softwares for my highier study. so kindly give tthe link for this software. I think you are able to solve my problem. please reply me.



with Regards...

May 06, 2008 | Microsoft EXCEL 2004 for Mac

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

81 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...