How do I change the formula based on text in another cell...
Closed
GrimmLynne
Posts
1
Registration date
Friday October 25, 2013
Status
Member
Last seen
October 25, 2013
-
Oct 25, 2013 at 12:28 PM
Blocked Profile - Oct 25, 2013 at 01:13 PM
Blocked Profile - Oct 25, 2013 at 01:13 PM
Related:
- How do I change the formula based on text in another cell...
- How to change language in kmplayer - Guide
- Excel cell color formula - Guide
- Based on the values in cells b77 b81 c77 - Excel Forum
- How to change language in idm - Guide
- How do i change close friends highlights to public - Instagram Forum
1 response
Good Afternoon.
The logic for the formula you are looking for is in this format:
=if(logic test, true, false)
So, it would look like this:
cell a1 contains:
50
cell b1 contains:
=if(a1<49,"The value is less than 50","The Value is more than 50")
Cell b1 would now contain "The value is more than 50".
Please understand, you can nest logical if statements like so:
=if(logical test for test #1,if(logical test for #2,"true to test#2","false to test #2"),"false to test #1")
I hope this helps.
//ark
-Contributor
The logic for the formula you are looking for is in this format:
=if(logic test, true, false)
So, it would look like this:
cell a1 contains:
50
cell b1 contains:
=if(a1<49,"The value is less than 50","The Value is more than 50")
Cell b1 would now contain "The value is more than 50".
Please understand, you can nest logical if statements like so:
=if(logical test for test #1,if(logical test for #2,"true to test#2","false to test #2"),"false to test #1")
I hope this helps.
//ark
-Contributor
