Formula in excel to show amount in cell
Solved
Mayra
-
Nov 16, 2021 at 10:43 PM
vcoolio
vcoolio
- Posts
- 1356
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- August 11, 2022
Related:
- Formula in excel to show amount in cell
- How to copy a cell with formula in excel to another sheet - Guide
- 40 % add formula in excel cell ✓ - Forum - Excel
- How to make formula in excel cell for time? ✓ - Forum - Excel
- Excel vba run macro when cell value changes by formula ✓ - Forum - Excel
- Excel formula to find specific text in a cell ✓ - Forum - Word
2 replies
vcoolio
Nov 17, 2021 at 12:33 AM
- Posts
- 1356
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- August 11, 2022
Nov 17, 2021 at 12:33 AM
Hello Mayra,
Perhaps this is all you need:-
=IF(B2="Done",A2,"")
Drag the formula down as far as you need.
I hope that this helps.
Cheerio,
vcoolio.
Perhaps this is all you need:-
=IF(B2="Done",A2,"")
Drag the formula down as far as you need.
I hope that this helps.
Cheerio,
vcoolio.
vcoolio
Nov 17, 2021 at 12:55 AM
- Posts
- 1356
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- August 11, 2022
Nov 17, 2021 at 12:55 AM
You're welcome Mayra. I'm glad to have been able to assist.
Cheerio,
vcoolio.
Cheerio,
vcoolio.
Nov 17, 2021 at 12:41 AM
It really helps.
Thank you very much!