IF Function

Copper Contributor

HI!

How do I do, for example, if 16 slices come out of a cake, in a cell I get 16 that is equal to 1, and if for example I write 17 in the cell, it appears to me that they are two cakes. And so after the number 3 comes out if they are 33 slices

I have this in my formula =IF(D12<16,1,2)

1 Reply

Hi,

This is not an IF formula problem. Lets say total number of slices in one cake is in A1 and total number of slices required is in B1 you can find the number of total cakes needed by =Roundup(B1/A1;0)