Formula please

S

Shona

Hi

I need a formula in H2

If the figure in G2 is between D2 or E2 (or equal to either) put the number
that is in C2 otherwise put 0.

I think I'm nearly there with this

=IF(G2>=D2+AND(E2<=D2),C2,0)

but it works if I put a lower figure in D2 but not if I put a higher figure
in E2

Any ideas

Cheers Shona
 
B

Bob Phillips

Hi Shona,

=IF(AND(G2<=E2,G2>=D2),C2,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top