The problem that I'm having is that cell A1 has a formula that generates a percentage. The formula above isn't giving the correct answer.
What am I doing wrong?
I hope this helps you.
on Thisworkbook, put:
Private Sub Workbook_Open()
Then ...READ MORE
Use vlookup() as that is much easier ...READ MORE
Use this formula:
INDEX returns the first value ...READ MORE
Since the 'second dimension' could be just ...READ MORE
Please see MS Excel: COUNTIF Function (WS)
You should ...READ MORE
See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE
Use SUM() as an Array formula:
=SUM(IFERROR((AB22:AB1100 = ...READ MORE
Try this formula in cell W4:
The calculation ...READ MORE
=IFERROR(EXP(LN(REALLY_LONG_FORMULA – threshold)) + threshold, 0)
The ...READ MORE
If J17's value is a true or ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.