Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask Richard Your Own Question

Richard, Software Specialist

Category: Microsoft Office

Satisfied Customers: 36526

Experience: Over 15 year experience resolving Microsoft Office Issues

32989067

Type Your Microsoft Office Question Here...

Richard is online now

A friend wrote this formula for me:
=IF((X16),(Y16),IF(ISBLANK(X16),(SUM(Z16*$Z$5)+(AB16*

This answer was rated:

★★★★★

A friend wrote this formula for me: =IF((X16),(Y16),IF(ISBLANK(X16),(SUM(Z16*$Z$5)+(AB16*$AB$5)+(AC16*$AC$5)+(AD16*$AD$5)+(AE16*$AE$5)+(AF16*$AF$5)+(AH16*$AH$5)+(AI16*$AI$5) which works when there is a value in Y16. Does not work with no value in Y16 even with a 0. Receive a #VALUE! instead of answer.

Basically there is a lookup in Y16 based on the value in X16 with a value of 1 to 3. If the cell is blank or the value is 0, a calculation of (SUM(Z16*$Z$5)+(AB16*$AB$5)+(AC16*$AC$5)+(AD16*$AD$5)+(AE16*$AE$5)+(AF16*$AF$5)+(AH16*$AH$5)+(AI16*$AI$5) is required. The formula works on its own, I somehow cannot combine it with anything else to provide the answer. If the cell is not blank, use the value appearing in Y16.

- Click the following link: http://www.wikisend.com - Upload the file to that website - Once it is uploaded, the resulting page will display a "File ID" number. - Please, give me that "File ID Number"

Formula still not working for 'non-package' deals. I.E., For example, on Row 14, add a "1" under breakfast and under lunch and the total should become $53.

Not a problem. It is perfect. Now I know why I was not able to get the formula to work even with my friend's help. As this spreadsheet is going to be used for years to come and different people will be entering the data, having the computer to do the calculations is a tremendous help.

Thank you again. I have already rated your service.