Expanding the formula to include extra if statements

[IanJS]

Hi

I have the following formula

=IF(AND(C3=0,G3=0),"",IF(OR(C3>0,G3>0),1)) (located in cell H3)

This works perfectly well but I would like to change it to

IF C3 = 0 and G3 = 0 then H3 = ""
IF C3 > 0 and G3 = 0 then H3 = .5
IF C3 = 0 and G3 > 0 then H3 = .5
IF C3 > 0 and G3 > 0 then H3 = 1

Is this possible , I have spent ages but to no avail

Thanks

Ian

[AliGW]

Try this:

=IF(OR(AND(C3>0,G3=0),AND(C3=0,G3>0)),0.5,IF(AND(C3>0,G3>0),1,"")

[IanJS]

Much appreciated AliGW

I needed to put an extra ) at the end

Ian

[AliGW]

Quite possibly - I'm on my iPad in the garden!!!

Glad to have helped.

[IanJS]

Hope it is hot enough for you

[AliGW]

It's bloomin' gorgeous - 23 in the shade and clear, blue skies as far as the eye can see!!! ☀☀☀