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:

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 Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18343 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...