ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Comment using Cell value as part of it (https://www.excelbanter.com/excel-discussion-misc-queries/258580-conditional-comment-using-cell-value-part.html)

Alfredo

Conditional Comment using Cell value as part of it
 
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


All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com