If Formula help

oxicottin

Board Regular
Joined
Feb 21, 2007
Messages
126
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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
How about this in A2
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.
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,224,518
Messages
6,179,258
Members
452,901
Latest member
LisaGo

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top