Forum Discussion
Formula help (reflect text in cell depending on value of another cell)
I need help with the followig function, thanks in advance.
If cell A says $0.00, I need cell A2 to = No Fee
If cell A says $50.00, I need cell A2 to = Charge Fee
Hello Jennyffer
I don't think you are giving us the whole story. What about $15.00 or $86.00?
HI, thanks.
it's a specific fee for this particular templet, the total will always be 0 or 50 for each account (row)
So I would like th cell to autofill the text depending on the amount.
=LOOKUP(Cell A,{0,"No Fee";50,"Charge Fee"})
