using a value from a list in an IF formula
The formula works ,but its not returning the correct value...When transfer is
in the cell it inputs a 0 result rather than performing the calculation.
"Dave F" wrote:
I just tested your formula and it works whether there is a drop down or not.
Are you sure that the "TRANSFER" in your formula matches the value in the
drop-down?
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"johnnyz197034" wrote:
Im trying to use a value(which is a word ,not a number) in an IF formula but
its not working
Ex: =IF(C17="TRANSFER",C18*0.005,0)
TRANSFER is in a dropdown as part of a list.
Any help would be greatly appreciated!!!
|