Excel Formula

shravank30

Active Member
Adept
Aug 29, 2009
750
21
32
39
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
 
Last edited:

shravank30

Active Member
Adept
Aug 29, 2009
750
21
32
39
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