Re: IF Formula?

Tech-Archive recommends: Fix windows errors by optimizing your registry



On Oct 18, 3:40 pm, shane <sh...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
B9 = people
B8 = days and
0.5 = kilos

++++++++++++++++++++++=

Hi,

If I understood correctly, I would use the following:

=IF(A1="YES",(B8*B9*0.5)&" Kilos",0&" Kilos")

Hope it works


.