Hello, Im having trouble figuring out this formula. I have a cell A1 with a number in it and in A2 I want to multiply A1 * .20% but I only want it to show up to 1.2% and if there isnt a number in A1 I want it to be blank. How can I do this? Thanks!
=IF(A1*0.20>1.20,"",A1*0.20)