Formula in excel to show amount in cell
Solved/Closed
Mayra
-
Nov 16, 2021 at 10:43 PM
vcoolio Posts 1371 Registration date Thursday July 24, 2014 Status Moderator Last seen April 12, 2023 - Nov 17, 2021 at 12:55 AM
vcoolio Posts 1371 Registration date Thursday July 24, 2014 Status Moderator Last seen April 12, 2023 - Nov 17, 2021 at 12:55 AM
Related:
- Formula in excel to show amount in cell
- How to change date format in excel - Guide
- Number to words in excel formula - Guide
- How to enable vba in excel - Guide
- Mark sheet grade formula in excel download - Guide
- How to take screenshot in excel - Guide
2 replies
vcoolio
Posts
1371
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
April 12, 2023
252
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
1371
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
April 12, 2023
252
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!