| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help, Please
=IF(AND(B113="Anne",ISNUMBER(V113)), R113+S113)
What am I doing wrong? All I get is "VALUE", with no help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
