Need help on Logic test!!!
And, of course, if you don't care about the case where A10=0, this
reduces to
=IF(L4<=683+354*A10, "Free", IF(L4<=972+504*A10, "Reduced", "Paid"))
In article ,
JE McGimpsey wrote:
I may be being dense, but I have a hard time following your question. In
the unlikely case that I've understood it correctly, you could use
something like:
=IF(L4<=684+354*A10-(A10=1), "Free", IF(L4<=973+504*A10-(A10=1),
"Reduced", "Paid"))
|