I am trying to get an output in percentage from list of rows. Its like if sum of the value in row1 to row4 is 100%, then return 0% or subtract 100% with the sum of values in those rows or I wanted to pick a value in a specific row I15 and return that value.
I tried this formula =IF(OR(SUM(I14:I17)=100%),0,100%-SUM(I14:I17)) & its working before adding the last part (I15>10%),I15. When I add the last part (as mentioned below)
=IF(OR(SUM(I14:I17)=100%),0,100%-SUM(I14:I17),(I15>10%),I15))
I am getting error - "You have entered too many arguments for this function.
Any idea how to fix it or is there another approach to get result.
Bookmarks