IF formula reference error

G

Guest

So =IF(U4="","",IF(U4<'MDA Portfolio Summary'!H8,"ACQUIRE",IF(U4>'MDA
Portfolio Summary'!J8,"REDUCE",""))) was working, but now i get a REF error.
the values in H8 and J8 are percentages, and U4 is also a formula result as a
percentage. is this why i get a ref error, i cant find anything else wrong
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

value error 2
Excel error message - #VALUE! 2
reference to cells in other files: direct vs indirect 2
Excel 2003 - VBA - Remote access 3
Adding numbers and text 6
Formula to get sum from one 31 sheets to a summary sheet. 7
conditional formatting in Excel 2007 1
Formula to calculate % using negative values 3

Top