Formula in excel to show amount in cell

Solved
Mayra - Nov 16, 2021 at 10:43 PM
vcoolio
Posts
1356
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 11, 2022
- Nov 17, 2021 at 12:55 AM
Hello,

I need a formula that show the amount in another cell if some text is found in another cell. Like this;

A2: 500
B2: Done
C2: result to the formula>to show the amount of A2 if B2 is fill in with 'Done'

Hope anyone can help.
Thanks.

System Configuration: Windows / Chrome 95.0.4638.69

2 replies

vcoolio
Posts
1356
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 11, 2022
250
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.
0
Hi vcoolio.
It really helps.
Thank you very much!
0
vcoolio
Posts
1356
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 11, 2022
250
Nov 17, 2021 at 12:55 AM
You're welcome Mayra. I'm glad to have been able to assist.

Cheerio,
vcoolio.
0