View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default Formula Help, Please

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.