AI10:AL10 contain an "IF" formula that will return a result of either the value provided in the attached image or "0". I want to show the "MAX" Value in cell AG10 of the range AI10:AL10 but I receive a result of "0" . I have tried removing the result "0" so that it would simply show a result of "False", It still showed a result of "0" for the "MAX" FormulaCapture.JPG
What is the full IF formula, please? Better yet, can you please post the workbook rather than an image I can barely read?
Don
Please remember to mark your thread 'Solved' when appropriate.
First time user, Attached you should find the workbook.
Thanks for any help you can provide
Your IF formulas are returning text values. Get rid of the quotations around the numbers and then your MAX formula will work as expected.
You need to use:
=IF(AE10>0, 80,0)
rather than
=IF(AE10>0, "80","0")
and so on. That way you will get true numbers that MAX will recognize and you also won't have to manually align the cells to the right since numbers do that automatically.
You could simply select all those formula cells and Ctrl+H to bring up the Replace dialog, and then enter " in the Find box, leaving the Replace box empty and press Replace All, which will fix all of them at once.
On another note, in AE10, you can use this:
=YEAR(A$7)-YEAR(AD10)
and drag it down the entire column. The $ before the row reference locks the row reference.
Greatly appreciated, was banging my head against the desk for the past two days
Glad we could help. Thanks for the rep!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks