Formula in excel to show amount in cell
Solved/Closed
Mayra
-
Nov 16, 2021 at 10:43 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Nov 17, 2021 at 12:55 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Nov 17, 2021 at 12:55 AM
Related:
- Formula in excel to show amount in cell
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Percentage formula in excel marksheet - Guide
- Gif in excel - Guide
- Vat formula in excel - Guide
2 responses
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
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
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
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!