Excel If Help
Closed
Abby Hung
-
Mar 15, 2010 at 11:39 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 15, 2010 at 01:05 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 15, 2010 at 01:05 PM
Related:
- Excel If Help
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 15, 2010 at 01:05 PM
Mar 15, 2010 at 01:05 PM
=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)
