ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

2 Q & A posts tagged with percentage

Thu
Apr 9
2009

Microsoft Excel question?

I have a column of percentages E127:E132 and I need a formula that will return one answer ($250.00) if there are three or more items in the column above 98% and another answer ($0) if there aren't.


Answer

=IF( COUNTIF(E127:E132,0.98)>=3,250,0)

Paste this in a cell

VBAXLMan

Thursday 4/9/2009 8:23:55 AM
Tue
Apr 7
2009

Percentages in excel?

how do i calculate percentages on one column and post them on the next column?


Answer

If you have the number you want to get its percentage in A1, paste this in B1
=A1*50%
To get 50% of the value in cell A1

Then copy and paste B1 down to match all values in column A

VBAXLMan

Tuesday 4/7/2009 8:15:32 PM

Tags

History