How do I make a function for < and
select B1 Then write
=if(A1<20,"High",if(a1<26,"Within Margin",if(a126,"Low","N/A")))
"SeeStation" ...
Cell a1 contains the result of a function (19.94)
how can I make a function for B1
b1="High" if a1 is <20
b1="Low" if a1 is 26
b1="Within Margin" if 26<a120
b1="N/A" if false or if a1 contains "#VALUE" as a result of it's function
not being fullfilled?
Thanks!
|