Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting & decimal part of a number in cell | Excel Worksheet Functions | |||
Can Excel create a conditional Comment on a cell? | Excel Worksheet Functions | |||
Conditional formatting for part of a cell | Excel Discussion (Misc queries) | |||
Can I do conditional formula based on data in cell comment? | Excel Discussion (Misc queries) | |||
Conditional Formatting - part of cell only | Excel Discussion (Misc queries) |