0
What is the difference between simple formula and complex formula in Excel?
Wiki User
∙ 11y ago
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
A simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
Wiki User
∙ 11y ago
Wiki User
∙ 11y agoA simple formula would have a very basic job, like just to add cells together:
=B11+B12
A complex formula would be a lot longer and have some very complicated aspects. It could take a long time to work out before putting it together, like this one. This one will display a day of the week, the number of the month and the correct letter combination after it such as st or rd or th. It is specific to a particular set of cells on a particular spreadsheet, so if you were to copy it to one of yours, it would not work properly as it needs other values to be in particular cells.
=A5&" "&DAY(B5)&IF(OR(DAY(B5)=11,DAY(B5)=12,OR(DAY(B5)=13)),"th",VLOOKUP(VALUE(RIGHT(TEXT(DAY(B5),"0"),1)),$E$1:$G$5,3))
Add your answer:
Earn +20 pts
What is the difference between a simple animal and a complex animal?
complex animals have no back bones and simple animals have backbones
How do you find the difference between a simple compound complex and compound-complex sentences?
you are dumb cya
What is the difference between a simple query and a complex query?
A simple search is one based on a single term or criterion.
What is in an expression?
In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.
What is the difference between simple and complex queries?
a simple query is when you answer a database to do something and a complex/parameter query is a prompt to run a question to find something
What is the difference between simple and complex simple seizures?
Simple partial seizures occur in patients who are conscious, whereas complex partial seizures demonstrate impaired levels of consciousness.
What is an expression in excel?
In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.
What is the difference between renaissance and baroque architecture?
Renaissance straight an simple baroque complex and overflowing.
What is the major difference between simple and complex nervous systems?
simple-> doesnt coordinate activities unless there is a ganglia complex -> has a true brain with sensory structure that coordinates acitivties efficiently
What is the formula for difference between simple interest and compound interest?
P(r/100)^2
What is the difference between simple and complex organisms?
Simple Organism some simple organisms are made of single cell. Others are made of many cells that are similar Complex organisms in complex organisms, cells are organized into tissues, which make up organs. Organs form organ systems.
Difference between complex trust with 100 exemption and 300 exemption?
There is one main difference between exemptions in a trust. According to the IRS, a 100 exemption on a trust is a simple and personal trust, a 300 exemption is a complex trust, usually for a charitable organization.
