Formula please

[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

 

[Leo Heuser]

Hi Shona

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

Assuming D2 is smaller than E2

 

[Frank Kabel]

Hi
nearly there
try
=IF(AND(G2>=D2,G2<=E2),C2,0)

 

[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)

 

[Shona]

Thanks that's great

Cheers Shona

 

[Leo Heuser]

You're welcome.
Appreciate the feedback

Regards
LeoH