Conditional Comment using Cell value as part of it

A

Alfredo

What I'm trying to do is the following:

if cell(a1) is different from 0(zero) then, cell(b1) should have a comment
that say, the value of cell(c1) is the payment, next line the value of
cell(a1) was refund, next line Total for today = cell(c1)-cell(a1)

Example
a1 = $10.00
c1 = $30.00

B1 (comment):
$30.00 is the payment (c1)
$10.00 was refund (a1)

Total for today: $20.00 (c1-a1)

can anyone help me on that?

thanks in advance
 

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

VBA Coding Help for Beginner 0
Need help with IF statement (function) 1
Different cells that need to sum in one 4
Unique Value Count in 3 Columns Using Search Criteria 0
reverse pasting rows with alternate blank cells 0
What is this called in Excel or how it works? 0
Show value from one cell in another cell if today falls between a date range 5
How To Have A Cell Be Blank If... 2

Top