Microsoft 365 and Office | Excel | Other | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
In I5:
=IF(J5="", I4, J5)+14
Need help with excel formula?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Need help with excel formula:
=IF(OR(J5,J5+14),IF(J5,"",I4+14)), returns #value! when something is placed in J5 cell.
Attempting to create formula that will read if there is a value in cell J5 and if so will add 14 to that and put answer in I5 (where the formula resides). If there is no value in J5 will add 14 to the value in I4 and return that in cell I5.
Microsoft 365 and Office | Excel | Other | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
1 additional answer
Sort by: Most helpful
-
Anonymous
2024-07-16T15:25:08+00:00 Thank you!!