Related:
- Auto add or subtract between two cells
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Grand theft auto iv download apk for pc - Download - Action and adventure
- Stop facebook auto refresh - Guide
- Auto redial samsung - Guide
1 response
OK, there is a function called =IF.
It goes something like this:
=IF(logic_test,true,false)
You can nest IF's like so:
=IF(logic_test1,if(logic_test2,logic_test2_true_result,logic_test2_false_result),logic_test1_false_result)
So, with that being said, we can do:
=IF(B1>A1,B1-C1,B1+C1)
The above example checks to compare B1 and A1. If A1 is less than B1, then C1 is Subtracted from B1, and if it isn't, it adds it!
Use the above example to write our own!
Have fun!
It goes something like this:
=IF(logic_test,true,false)
You can nest IF's like so:
=IF(logic_test1,if(logic_test2,logic_test2_true_result,logic_test2_false_result),logic_test1_false_result)
So, with that being said, we can do:
=IF(B1>A1,B1-C1,B1+C1)
The above example checks to compare B1 and A1. If A1 is less than B1, then C1 is Subtracted from B1, and if it isn't, it adds it!
Use the above example to write our own!
Have fun!