If(And) formulas

[mikeywhits]

Hi guys,

Is it possible to combine the below into 1 monster of a formula???
=IF(AND(H2<=TODAY(),O2<50%),"R","")
=IF(AND(H2<=TODAY(),O2>50%,O2<99%),"A","")
=IF(AND(H2<=TODAY(),O2>100%),"G","")

Thanks,

Mike

 

[njimack]

=if(h2<=today(),if(o2<50%,"r",if(o2<1,"a","g")),"")

 

[Jonmo1]

Try

=IF(H2<=TODAY(),LOOKUP(O2,{0,0.5,1},{"R","A","G"}),"")