Formula in excel to show amount in cell

Solved
Report
-
Posts
1325
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 17, 2021
-
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

Posts
1325
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 17, 2021
240
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.
Hi vcoolio.
It really helps.
Thank you very much!
Posts
1325
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 17, 2021
240
You're welcome Mayra. I'm glad to have been able to assist.

Cheerio,
vcoolio.