repeating values



I have this formula to calculate my value balance:

This works but when I copy my formula down the column I get repeating values
for blank cells.

What I want to do is "" is c5 is blank and if it isn't blank I want to do
either of the other formulas.
Can i have two = if to do this?




You're going to need to nest another IF testing one of the other values (or
testing C5 again), as

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

repeated value 8
repeated values 1
repeating values 2
repeated numbers or value 2
Counting repeated values 1
Autofill - repeating values 3
maximum repeated value 2
find repeating values 6