Conditional statement
Closed
carlosbathan
Posts
1
Registration date
Friday November 15, 2013
Status
Member
Last seen
November 15, 2013
-
Nov 15, 2013 at 01:48 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 18, 2013 at 11:24 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 18, 2013 at 11:24 AM
Related:
- Conditional statement
- Fenix internet on bank statement - Guide
- Application for bank statement sbi - Guide
- Excel if statement - Guide
- An if statement nested within another if statement will produce how many possible results? - Guide
- Vba case statement - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 18, 2013 at 11:24 AM
Nov 18, 2013 at 11:24 AM
I think this is the formula Carlos is looking for:
=IF(A1>=0,A1,IF(A1="",A2,IF(A2="",A3,"")))
Or were you just testing Carlos, Mark?
To see if he understood the syntaxis.
Anyway ...
Best regards to both,
Trowa
=IF(A1>=0,A1,IF(A1="",A2,IF(A2="",A3,"")))
Or were you just testing Carlos, Mark?
To see if he understood the syntaxis.
Anyway ...
Best regards to both,
Trowa
THIS MAKES ME SO HAPPY! YOU ARE THE MAN!
EVERYBODY gather around and see the work that Carlos has completed.
I DO NOT mind helping someone that helps themselves. Please reference the following for conditional if then statements in EXCEL.
Once again, great job on TRYING!
=if(logical_test,true, false)
Then you can nest the same logic into one of the true / false as in:
=IF(A1>=0,IF(A2<>"",A2),A3)
You almost had it...way to GO!
//ark
-Moderator/Contributor
EVERYBODY gather around and see the work that Carlos has completed.
I DO NOT mind helping someone that helps themselves. Please reference the following for conditional if then statements in EXCEL.
Once again, great job on TRYING!
=if(logical_test,true, false)
Then you can nest the same logic into one of the true / false as in:
=IF(A1>=0,IF(A2<>"",A2),A3)
You almost had it...way to GO!
//ark
-Moderator/Contributor
