IF Formula

[Jemma]

Hi i need an IF formula which basically says 'If the contents in cell A1 are
less that 60 and the contents of cell A2 is 4 i want A3 to then show 10%'

is it even possible to have multiple if's in one formula?

 

[Max]

Something like this in A3: =IF(AND(A1<60,A2=4),10%,"")
with A3 formatted as percentage to taste
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik

 

[Jemma]

excellent thank you

Something like this in A3: =IF(AND(A1<60,A2=4),10%,"")
with A3 formatted as percentage to taste
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik

 

[Max]

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik