Solved help with excel formuals

January 10, 2015 at 11:45:32
Specs: Windows 7
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


See More: help with excel formuals

Report •


#1
January 10, 2015 at 13:21:39
✔ Best Answer
Try this

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

See how that works for you.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
January 11, 2015 at 02:01:08
Brill thanks very much :)

Report •
Related Solutions


Ask Question