Is this formula possible???

[DannyCog]

Hi can someone please help me with this formula

Is it possible?

F10 is auto calculated with a formula from the manual figure entered in to E10

If G10 = YES, then H10 should show the figure in F10 but divided by 100.

Example F10 has 16.16 in the cell but H10 will show 0.1616

If G10 = NO, I want H10 to show 0.00

Thanks

Danny

[Domski]

Assuming G10 can show only yes or no: =IF(G10="Yes",F10/100,0)

Dom

[Jamesr571]

Danny,

yes it is possible.

use the following in H10;

Please Login or Register  to view this content.

[DannyCog]

Dom,

Thank you for this. It was sending me under ha!

Any chance you can help me with this one.

I have 10 cells ranging from G10 to G19. If 4 of those cells say YES and 6 say No for example, I want K2 to show 4 as there are 4 cells showing yes and I need that to auto calc if there is there is another amount of cells saying yes.

Sorry to be a pain

Thanks Danny

[brokenbiscuits]

K2=countif(G10:G19,"YES")

[DannyCog]

Thank you very much