Formula in excel to show amount in cell
Solved/Closed
Mayra
-
Nov 16, 2021 at 10:43 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Nov 17, 2021 at 12:55 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Nov 17, 2021 at 12:55 AM
Related:
- Formula in excel to show amount in cell
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- How to take screenshot in excel - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
2 responses
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Nov 17, 2021 at 12:33 AM
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
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Nov 17, 2021 at 12:55 AM
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!