I am getting an error with Microsoft excel calculation. I am using Microsoft Excel 2003 and when calculating with a formula I am getting #VALUE!. The formula is put as =C2*.25*B2*.4*.05. Please help me solve this problem.
I think what Simey's trying to say is that it's probably not recognizing one of the cells as numerical. Go into both C2 and B2 and use the format, number stuff (can't remember where it is in 2003) to format them.
*light bulb* - the currency amount - did you enter a '$' or whatever symbol in front of the numbers? That would change it to text - to view as currency you should format as currency and not enter the symbol!
If you typed the currency sign directly in to the cell then remove the currency sign and use the 'number formatting' to format as the currency...hmmm I just typed in the $ before numbers and that works too....check to see if there is the character ' before the currency sign....
No no its not confidential. Its a keyword research excel sheet. And the currency values are in Rs which is the symbol for Indian rupees. I can send it but you have Excel 2007 not sure if the excel sheet will open properly in your computer.
Just sent the file back to you: -I used edit replace to remove the 'rs.' -I saved as an excel file rather than the comma delimited file. -I added the formula - only the values remained in the file you sent me