Excel If Help
Closed
Abby Hung
-
Mar 15, 2010 at 11:39 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 15, 2010 at 01:05 PM
rizvisa1 Posts 4479 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 date format dd.mm.yyyy - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Screenshot in excel - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
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)