Previous Topic Next Topic

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

Answer 1 / 2
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.
Report

Hi vcoolio.
It really helps.
Thank you very much!
Answer 2 / 2
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.
Reply Ask a question