I am attempting to add 3 cells together in 3 seperate columns and have the total value within the cell not to exceed a fixed value. I have placed an example below to see if someone new of a better formula to use. The columns of B,C & D are random numbers and can be chnaged but Excel would need to input its own values. Column A is the fixed value for each row. Thanks
Natural Habitat mē A B C Total 8860 1368 3928 12125 Total of Sum of B2 2 less than value in A2
7968 10637 1472 8705 Total of Sum of B2 2 less than value in A3
10762 12807 11114 14191 Total of Sum of B2 2 less than value in A4
6069 795 2815 10160 Total of Sum of B2 2 less than value in A5
13643 3070 7284 6969 Total of Sum of B2D:2 less than value in A6 4001 888 11231 11178 Total of Sum of B2D:2 less than value in A7 8334 5941 7357 9400 Total of Sum of B2D:2 less than value in A8 12201 6044 7004 6313 Total of Sum of B2D:2 less than value in A9
In your above example. the first row looks like
8860 1368 3928 12125
The first number is your Natural Habitat column that will be used as your number to compare against.
so in the cell to the right of 12125, you should put something like. =IF(SUM(B2: D2)>A2, SUM(B2: D2),"sum is less than original number")
I hope that helps,
Simi
Bookmarks