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

The site seems to be screwy, this is a test.

"T. Valko" wrote:

The problem is he

R113+S113

One of those cells, or both, probably contain a TEXT entry.

Are there formulas in those cells?

--
Biff
Microsoft Excel MVP


"EMW103" wrote in message
...
=IF(AND(B113="Anne",ISNUMBER(V113)), R113+S113)

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