Formula Help, Please
 

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

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

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.

Formula Help, Please
 

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.

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.

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.

Formula Help, Please
 

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?

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

Formula Help, Please
 

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" wrote:

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?

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

Formula Help, Please
 

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

"FARAZ QURESHI" wrote:

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" wrote:

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?

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

Formula Help, Please
 

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" wrote:
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?

Formula Help, Please
 

THAT'S IT!

Many thanks.

"Max" wrote:

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" wrote:
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?