EXCEL VALIDATION

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
If I am having A1 is fixed value and E1= B1+C1+D1 & BUT E1 SHOULD NOT BE MORE THAN A1, IN HOW I CAN VALIDATE E1 WITH A1

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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)