View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
EMW103 EMW103 is offline
external usenet poster
 
Posts: 20
Default Formula Help, Please

They definitely are, they're currency numbers. Thought they are both the
result of other formulas: does that make a difference?

"FARAZ QURESHI" wrote:

Check that R113 & S113 are both numbers. Use Isnumber() for both.

"EMW103" wrote:

=IF(AND(B113="Anne",ISNUMBER(V113)), R113+S113)

What am I doing wrong? All I get is "VALUE", with no help.