One cell two formulas
Solved/Closed
fanderduck
Posts
2
Registration date
Thursday August 12, 2010
Status
Member
Last seen
August 15, 2010
-
Aug 13, 2010 at 10:07 AM
jack4rall Posts 6428 Registration date Sunday June 6, 2010 Status Moderator Last seen July 16, 2020 - Aug 15, 2010 at 04:56 PM
jack4rall Posts 6428 Registration date Sunday June 6, 2010 Status Moderator Last seen July 16, 2020 - Aug 15, 2010 at 04:56 PM
Related:
- One cell two formulas
- Spreadsheet formulas - Guide
- Little alchemy formulas - Guide
- If cell contains date then return value ✓ - Office Software Forum
- Ms excel marksheet formulas pdf - Guide
- An example of a cell is a blank cell ✓ - Programming Forum
1 response
fanderduck
Posts
2
Registration date
Thursday August 12, 2010
Status
Member
Last seen
August 15, 2010
Aug 15, 2010 at 04:41 PM
Aug 15, 2010 at 04:41 PM
I figured it out. Here is the answer.
=IF(I18="USD",SUM(P18:T18),SUM(P18:T18)/13)
=IF(I18="USD",SUM(P18:T18),SUM(P18:T18)/13)
Aug 15, 2010 at 04:56 PM
Thanks for coming back to post the answer.