Hello!
I have 3 different outcomes depending on the situation and its for me to choose the outcome.
I have a Sum cell and the 3 outcomes are 8%, 10% and 12%
I have made cheackboxes for the diffrent outcomes which give the the cell to the righy of the cheackbox a text "TRUE" or "FALSE" depending on if its checked or not.
Now i want a fucction which multiplys the sum cell with the increse if the checkbox is checked.
I have a following function but i dont get it to multiply when i check the inbox. What do i do wrong?
=F24*IF(K3="TRUE";1,08;IF(K4="TRUE";1,1;IF(K5="TRUE";1,15;1)))
Thanks in advance!
Kind regards // Alan
Bookmarks