IF AND Function - Microsoft Community

hi,

is possible have multiple logical test (more 2) , multiple value (more 2) in 1 function/formula using if and?

below detail applied in 1 formula:

if cell a1 (>=70%) , b1 (>=50%) = "promoted next level"

if cell a1 (<70%) , b1 (<50%) = "retained"

if cell a1 (<70%) , b1 (>=50%) = "retest"

if cell a1 (>=70%) , b1 (<50%) = "retest"

then try short formula:

=if(b1>=0.5,if(a1>=0.7,"promoted next level","retest"),"retained")

regards,

amit tandon

www.globaliconnect.com

if said response answers question please mark answer.

Office / Excel / Windows 10 / Office 365 Home