Trying to write this formula but can’t get it to work, see below

If column “B” has a N/A then put a 0 in column “C” if “B” does not equal N/A populate “C” with whatever is in column “A”
Amount Ending Balance Total
-4,668.91 3508.23
-0.42 8177.14
-818.48 N/A
-8,128.44 8177.56
+2,349.91 16306.0

---

Answer from Richard Rost:

Sounds like it should be:

C1:  =IF(B1="N/A",0,A1)

Easy enough?

You can use the IF function to have Excel place a value in a cell based on one or more conditions or values in other cells.

See this FREE tutorial on my web site for more information on how to use the IF function:

http://www.599cd.com/tips/excel/misc/if-function-sales-tax.asp?key=BlFAlEx