# If Formula help

#### oxicottin

##### Board Regular
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!

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### stnkynts

##### Board Regular
Code:
``=IF(A1="","",IF(A1*0.2>1.2,"",A1*0.2))``

The percentages might gum it up a little since .2% is actually .002 i wasn't sure which way you wanted to go. You may have to update numbers to fit.

#### oxicottin

##### Board Regular
stnkynts, thanks for the reply.... Im using 2007 and found out that there is a check box in the options to not show zeros so that fixed that. Now for the formula. I removed the =IF(A1="","", and went with the second half. Im getting a 120% instead of a 1.2% AND it only shows that when I reach that number. What I was needing is if I had a 1 in A1 then where I had the formula it would show 0.2% and if I had a 6 then it would show 1.2% BUT if I had a 7, 8, 9 and so on it would still show a 1.2%. How can I do that?

Code:
``=IF(A1*0.20>1.20,"",A1*0.20)``

#### shift-del

##### Well-known Member
Hi

Code:
``=MIN(A1*0.2%,1.2%)``

#### oxicottin

##### Board Regular
Hi

Code:
``=MIN(A1*0.2%,1.2%)``

Thanks that worked great

Replies
18
Views
751
Replies
2
Views
146
Replies
8
Views
537
Replies
2
Views
176
Replies
4
Views
141

1,190,913
Messages
5,983,532
Members
439,848
Latest member
timmyo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back