| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Error being returned
This following formula is returning #VALUE!
=P207/1.4 I have tried to modify with the following: =IF((ISERROR(Sheet1!P207/1.4)," ",(Sheet1!p207/1.4,0)) It is obviously not correct, can someone help with this? Thanks Pat |
|
#2
|
|||
|
|||
|
=IF(ISERROR(Sheet1!P207/1.4)," ",(Sheet1!p207/1.4))
would be the correct syntax "Pat" wrote in message ... This following formula is returning #VALUE! =P207/1.4 I have tried to modify with the following: =IF((ISERROR(Sheet1!P207/1.4)," ",(Sheet1!p207/1.4,0)) It is obviously not correct, can someone help with this? Thanks Pat |
|
#3
|
|||
|
|||
|
What do you get with =ISNUMBER(P207)?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Pat" wrote in message ... This following formula is returning #VALUE! =P207/1.4 I have tried to modify with the following: =IF((ISERROR(Sheet1!P207/1.4)," ",(Sheet1!p207/1.4,0)) It is obviously not correct, can someone help with this? Thanks Pat |
|
#4
|
|||
|
|||
|
What do you get with =ISNUMBER(P207)?
FALSE "Bernard Liengme" wrote in message ... What do you get with =ISNUMBER(P207)? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Pat" wrote in message ... This following formula is returning #VALUE! =P207/1.4 I have tried to modify with the following: =IF((ISERROR(Sheet1!P207/1.4)," ",(Sheet1!p207/1.4,0)) It is obviously not correct, can someone help with this? Thanks Pat |
|
#5
|
|||
|
|||
|
False, of course indicates that P207 is not a number;
Non-numbers divided by 1.4 would naturally yeild #VALUE! HTH -----Original Message----- What do you get with =ISNUMBER(P207)? FALSE "Bernard Liengme" wrote in message ... What do you get with =ISNUMBER(P207)? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Pat" wrote in message ... This following formula is returning #VALUE! =P207/1.4 I have tried to modify with the following: =IF((ISERROR(Sheet1!P207/1.4)," ",(Sheet1!p207/1.4,0)) It is obviously not correct, can someone help with this? Thanks Pat . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel SQL.Request restricts data returned to array | Excel Worksheet Functions | |||
| Formatting of the Returned Value of a Formula Q | Excel Worksheet Functions | |||
| #Value! Returned ? | Excel Worksheet Functions | |||
| Address returned, Not Contents? | Excel Discussion (Misc queries) | |||
Linear Mode
