Excel If Help
Closed
Abby Hung
-
15 Mar 2010 à 11:39
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 15 Mar 2010 à 13:05
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 15 Mar 2010 à 13:05
Related:
- Excel If Help
- Excel mod apk for pc - Download - Spreadsheets
- Excel if color - Guide
- Excel online macros - Guide
- Kernel for excel repair - Download - Backup and recovery
- Vat calculation excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
15 Mar 2010 à 13:05
15 Mar 2010 à 13:05
=IF(A2>300, A2-300, 300-a2)
Alternatively this will do the same (as it seem you just care for absolute value)
=abs(a2-300)
Alternatively this will do the same (as it seem you just care for absolute value)
=abs(a2-300)
