IFS formula modification required

[Vishaal]

Hi All

Thanks in advance,

we are using the following formula in A2,

= ARRAYFORMULA (ifs ((F2:F-J2:J)>10, "C",(F2:F-J2:J)>0, "B",(F2:F-J2:J)<=0, "A"))

want to add one more condition if F2:F = blank then A2=""

help pls

 

[jasonb75]

That looks like a googlesheets formula, not an excel formula.

I've submitted a request for a moderator to move it to the correct part of the forum.

 

[Vishaal]

yes, thanks for update, i will post it in google sheet formula from next time,

thanks jasonb75