If statement
Closed
flatfoot
-
Dec 19, 2009 at 08:10 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 19, 2009 at 09:35 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 19, 2009 at 09:35 PM
Related:
- If statement
- Fenix internet on bank statement - Guide
- An if statement nested within another if statement will produce how many possible results? - Guide
- Excel if statement - Guide
- Application for bank statement sbi - Guide
- Vba case statement with string - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 19, 2009 at 09:35 PM
Dec 19, 2009 at 09:35 PM
remove that dollar sign in the formula. with the dollar sign it tests only C2 in all cases if the data is in column C
how to do this easily
highlight the cell with the formula
click control+H
in the " find what" window type
$
in "replace with" window leave it blank
click "replac eall" at the bottom
all the dollars will be removed.
get back to the newsgroup if this solves the problem
how to do this easily
highlight the cell with the formula
click control+H
in the " find what" window type
$
in "replace with" window leave it blank
click "replac eall" at the bottom
all the dollars will be removed.
get back to the newsgroup if this solves the problem
