Home |
Search |
Today's Posts |
#1
|
|||
|
|||
error checking reports a value in the formula is of the wrong dat.
A1=($280,000)
B1=(=A1*0.05/12) C1=($2000) D1=(=A1+B1-C1) |
#2
|
|||
|
|||
Hi
have you entered the dollar sign manually or is this a format. If entered manually try to remove the $ sign and try again (use 'Format - cells' to add this sign as format) -- Regards Frank Kabel Frankfurt, Germany wrote: A1=($280,000) B1=(=A1*0.05/12) C1=($2000) D1=(=A1+B1-C1) |
#3
|
|||
|
|||
gerald
Perhaps 280,000 0r 2000 are Text and not numerics. Quick check....... In A2 enter =ISNUMBER(A1) will return TRUE or FALSE Same for C1 If FALSE, copy an empty cell formatted to General and select your numbers then Paste SpecialAdd)KEsc. Gord Dibben Excel MVP On Sun, 7 Nov 2004 09:52:01 -0800, " wrote: A1=($280,000) B1=(=A1*0.05/12) C1=($2000) D1=(=A1+B1-C1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Help w/ algebra equations (wrong formula used in my first 2 posts! | Excel Worksheet Functions |