Frisi

Q: IF funktion

Hi,


I have a checklist and if B3 is checked the value of F3 is displayed in G3 and G should accumulate (see screehshot)


(IF B3=TRUE;F3) works with row 3

to accumulate I used the formular (IF B4=TRUE;F4+G3)


but if B4 and B5 are not checked, there is the word FALSE in the cell

and if B6 and B7 are checked than, it starts to accumulate in B6


I would like that if B is not checked, the cell is empty

and it accumulates with the sum of the cell above which had a value.


Thanks for help.


Best

Tina

Bildschirmfoto 2016-09-17 um 19.21.29.png

MacBook Pro, iOS 10

Posted on Sep 17, 2016 10:25 AM

Close

Q: IF funktion

  • All replies
  • Helpful answers