Formula Help, Please

E

EMW103

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

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

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?
 
E

EMW103

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

EMW103

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

T. Valko said:
The problem is here:

R113+S113

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

Are there formulas in those cells?
Click to expand...
 
E

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?
 
F

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.
 
E

EMW103

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

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
 
Top