EXCEL VALIDATION
Closed
rao.cv2
-
Oct 24, 2009 at 06:14 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 25, 2009 at 12:04 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 25, 2009 at 12:04 AM
Related:
- EXCEL VALIDATION
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 25, 2009 at 12:04 AM
Oct 25, 2009 at 12:04 AM
do you mean to say that if B1+c1+d1 is more than A1 E1should be A1
try(if necessary modify) this formula
=IF(SUM(B1:D1)<=A1,SUM(B1:D1),A1)
try(if necessary modify) this formula
=IF(SUM(B1:D1)<=A1,SUM(B1:D1),A1)
