Excel Formula

[shravank30]

Hi

A small problem but vexing me

In an excel sheet i have a formula in Cell C1 which is =A1*B1
Then in D1 i have a formula =C1*0.0001
However, I also want that in case the result is less then 20, minimum result should be 20 in D1

I shall be grateful if you can give me the formula i should write in D1

Thanks for helping

 

[whatsinaname]

D1=IF((C1*0.0001<20),20,C1*0.0001)

 

[shravank30]

Thanks for the solution.
But there is something wrong.
I am getting the output of false instead of a number (The result was less then 15 just FYI)
I shall be grateful if you correct the formula

Thanks for advising

 

[asingh]

Put this in D1

=IF((C1*0.0001)<20,20,C1*0.0001)

 

[shravank30]

Thanks
Its working