If statement
Closed
flatfoot
-
19 Dec 2009 à 08:10
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 19 Dec 2009 à 21:35
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 19 Dec 2009 à 21:35
Related:
- If statement
- More than 1 if statement excel - Guide
- Fenix internet on bank statement - Guide
- Sbi account statement - Guide
- Excel if statement with dates - Guide
- Vba case statement with string - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
19 Dec 2009 à 21:35
19 Dec 2009 à 21:35
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
