How get a cell to work out a cell to calculate 2 formula Ie If G3<= 50 and D3<= 10 give an answer of 5 if true and 10 if false Thanks

Try this =IF(AND(G3<=50,D3<= 10),5,10)

See how that works for you.

MIKE

message edited by mmcconaghy

Brill thanks very much :)

Ask Your Question

Weekly Poll

Do you agree with Google's decision to shut down Google+?

Discuss in The Lounge

Poll History