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 January 16, 2023 - Nov 18, 2013 at 11:24 AM
i want to create a conditional statement to formulate below

if A1=>0 then equal the value, then if it is blank then get the value or number from A2,if A2 is blank then get the number value from A3

I have formulated it this way =if ((A1>= 0, A1, A2, A3)) but it wont work

would anyone help me please?

2 replies

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
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


1
Blocked Profile
Nov 15, 2013 at 09:26 AM
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
0