Need formula

[Arunachalam1983]

Hi everyone!

If A1 has the text "Cement" then it should calculate and produce result in A5 like this (A2/105*100). A2 will have some numerical value. If A1 does not have Cement then A5 should show 0.

Please advise and provide a formula for the above request.

 

[Kingarvind1]

Below formula will go in A5

=IF(A1<>"Cement",0,(A2/105*100))

 

[Arunachalam1983]

It gives 0 as answer, even if A1 has cement.

 

[JackDanIce]

Try:

=(A1="Cement")*(A2/105*100)

 

[Arunachalam1983]

Used the formula =(A1="Cement")*(A2/105*100) in A5. It is still the same, answer is 0.

 

[JackDanIce]

When I put Cement into A1 and 3 into A2, with the suggested formula, I got 2.857143 in A5
When I deleted A1, then I get 0 in A5
I'm using Excel 2016

Try:

=--(A1="Cement")*(A2/105*100)

 

[Ryan1996]

=IF(A1="cement", (A2/105*100),"0") will work as long as you have some data in A2 otherwise it will show 0.

 

[Arunachalam1983]

This works fine. Thanks, Ryan.

 

[JackDanIce]

Arunachalam, Ryan confirmed my suggested formula works, as long as A2 is not blank and I suggested adding -- to it if what originally suggested didn't work.

What do you have working now and is it because A2 is not blank?