Conditional statement

[Closed]
Report
Posts
1
Registration date
Friday November 15, 2013
Status
Member
Last seen
November 15, 2013
-
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
-
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

Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
481
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month


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