Excel Formulas

[thifu3]

hi everyone.


my question is if a cell value is more than some value how i add it to another cell.

for example. i can only accumulate 8 off days and if it exceeds the amount it should forfeit. so, if it is 9 then i want it to be added in "forfeit" column.

 

[kuldeepjainesl]

Hi Thifu,


Does it solve your concern:


Data set


A B C

1 1 1

2 2 2

1 3 1

3 4 3

6 5 6

9 6 15


Try this formula =IFERROR(IF(A2>8,(B2+A2),A2),"")


Regards,

Kuldeep

 

[Hui]

Thifu


The best way to get a meaningful answer is tom post a sample file

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook