Formula Help, Please

[EMW103]

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

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

 

[T. Valko]

The problem is here:

R113+S113

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

Are there formulas in those cells?

 

[EMW103]

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

 

[EMW103]

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

The problem is here:

R113+S113

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

Are there formulas in those cells?

 

[EMW103]

OK, trying to reply again: yes, both the R and S cells are the result of
formulas, and the S cell formula has a text as one of its values. Is that
the problem?

 

[FARAZ QURESHI]

Try:

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

and also

=and(isnumber(r113),isnumber(s113))

To check the both numbers are text or numbers.

 

[EMW103]

No luck, I'm still getting "VALUE". Is that because both the R and S cells
are the result of formulas?

 

[Max]

Maybe just use SUM, which ignores text:
=IF(AND(B113="Anne",ISNUMBER(V113)),SUM(R113:S113),"")

(Added a missing FALSE part of it to the IF, adapt the "" to suit)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik

 

[EMW103]

THAT'S IT!

Many thanks.

Maybe just use SUM, which ignores text:
=IF(AND(B113="Anne",ISNUMBER(V113)),SUM(R113:S113),"")

(Added a missing FALSE part of it to the IF, adapt the "" to suit)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik