G
Guest
How do I simply find text in a string within a cell and if true add the value
from another string and if false simply keep the current value for a running
total. When I enter the formula
IF(FIND(B15,"FEE"),E14,E14+C15)
It returns the #VALUE! error.
In this example I am placing this in cell E15 to create a running total of
all fees charged.
How do I format the formula to get an IF THEN ELSE type solution?
from another string and if false simply keep the current value for a running
total. When I enter the formula
IF(FIND(B15,"FEE"),E14,E14+C15)
It returns the #VALUE! error.
In this example I am placing this in cell E15 to create a running total of
all fees charged.
How do I format the formula to get an IF THEN ELSE type solution?