Formula Question

R

Rodney

Example of what it is doing:
1 A B
2 540.00 -60.00 Formula in Column B: =A2-600
3 700.00 100.00
=A3-600
4 -600.00
=A4-600
5 -600.00
=A5-600
6 -600.00
=A6-600
7 Total -1760.00

What is the correct formula for Column "B" where there will be no value in
"B" unless there is a value in Column "A"?

Example of what I would like for it to do:
1 A B
2 540.00 -60.00 Formula in Column B: =A2-600
3 700.00 100.00
=A3-600
4 0.00
=A4-600
5 0.00
=A5-600
6 0.00
=A6-600
7 Total 40.00

Thanks for your assistance.

Rodney
 

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

Formula For Excel 3
Search cell value in same column 3
Sum formula 3
Sort with IF functions? 5
How to determine the value - 19 Jan? 2
Help Creating Excel Formula 4
Column Heading on each row in pivot table 1
How to dynamically add up varying # of cells base on a value 6

Top