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