I have data that I want to pull from a table but want to use a formula to
calculate the answer to allow for variance. In normal english the formula I
am trying to use is =If the Max-Average/Average is <1 then take the Average
and add 1/2 of the standard deviation. The formula below provides me with a
"False" answer instead of a number figure.

=IF 'Stats Table'!$C$15<0, IF ('Stats Table'!$C$14-'Stats
Table'$C$15/'Stats Table'!$C$15 <1, then 'Stats Table'!$C$15+'Stats
Table!$C16*B15)

Can someone please tell me what I am doing wrong with this formula? Thank
you for your help and happy holidays!

BearsFan

Every IF statement needs a true result & a false result. You need to close
off the false results for you IF statements. e.g.,

=if(a11,true,false)

'Nested example
=if(a11,if(a22,true,false),false)
--
http://HelpExcel.com




"bearsfan" wrote:

I have data that I want to pull from a table but want to use a formula to
calculate the answer to allow for variance. In normal english the formula I
am trying to use is =If the Max-Average/Average is <1 then take the Average
and add 1/2 of the standard deviation. The formula below provides me with a
"False" answer instead of a number figure.

=IF 'Stats Table'!$C$15<0, IF ('Stats Table'!$C$14-'Stats
Table'$C$15/'Stats Table'!$C$15 <1, then 'Stats Table'!$C$15+'Stats
Table!$C16*B15)

Can someone please tell me what I am doing wrong with this formula? Thank
you for your help and happy holidays!

BearsFan

In this case, the false arguments are needed because the OP does not wish for
FALSE to be returned, but I disagree that every IF statement needs both TRUE
and FALSE arguments. I have seen some array formulae that nested an IF
statement inside of another function that ignores FALSE (such as Average), so
it was okay to leave out the FALSE argument in that situation.


"galimi" wrote:

Every IF statement needs a true result & a false result. You need to close
off the false results for you IF statements. e.g.,

=if(a11,true,false)

'Nested example
=if(a11,if(a22,true,false),false)
--
http://HelpExcel.com




"bearsfan" wrote:

I have data that I want to pull from a table but want to use a formula to
calculate the answer to allow for variance. In normal english the formula I
am trying to use is =If the Max-Average/Average is <1 then take the Average
and add 1/2 of the standard deviation. The formula below provides me with a
"False" answer instead of a number figure.

=IF 'Stats Table'!$C$15<0, IF ('Stats Table'!$C$14-'Stats
Table'$C$15/'Stats Table'!$C$15 <1, then 'Stats Table'!$C$15+'Stats
Table!$C16*B15)

Can someone please tell me what I am doing wrong with this formula? Thank
you for your help and happy holidays!

BearsFan

happy holidays too!

=IF(and('Stats Table'!$C$15<0, 'Stats Table'!$C$14-'Stats
Table'$C$15/'Stats Table'!$C$15 <1),'Stats Table'!$C$15+'Stats
Table!$C16*B15,"ver data!")

dribler2

"bearsfan" wrote:

I have data that I want to pull from a table but want to use a formula to
calculate the answer to allow for variance. In normal english the formula I
am trying to use is =If the Max-Average/Average is <1 then take the Average
and add 1/2 of the standard deviation. The formula below provides me with a
"False" answer instead of a number figure.

=IF 'Stats Table'!$C$15<0, IF ('Stats Table'!$C$14-'Stats
Table'$C$15/'Stats Table'!$C$15 <1, then 'Stats Table'!$C$15+'Stats
Table!$C16*B15)

Can someone please tell me what I am doing wrong with this formula? Thank
you for your help and happy holidays!

BearsFan

Thanks for the help folks! Dribler2, your forumula worked like a charm!



"dribler2" wrote:

happy holidays too!

=IF(and('Stats Table'!$C$15<0, 'Stats Table'!$C$14-'Stats
Table'$C$15/'Stats Table'!$C$15 <1),'Stats Table'!$C$15+'Stats
Table!$C16*B15,"ver data!")

dribler2

"bearsfan" wrote:

I have data that I want to pull from a table but want to use a formula to
calculate the answer to allow for variance. In normal english the formula I
am trying to use is =If the Max-Average/Average is <1 then take the Average
and add 1/2 of the standard deviation. The formula below provides me with a
"False" answer instead of a number figure.

=IF 'Stats Table'!$C$15<0, IF ('Stats Table'!$C$14-'Stats
Table'$C$15/'Stats Table'!$C$15 <1, then 'Stats Table'!$C$15+'Stats
Table!$C16*B15)

Can someone please tell me what I am doing wrong with this formula? Thank
you for your help and happy holidays!

BearsFan

thanks for the remarks.
Its your forumula, i just arrange it to fit them with excel.
happy holidays hohoho
4pinoy:)

"bearsfan" wrote:

Thanks for the help folks! Dribler2, your forumula worked like a charm!



"dribler2" wrote:

happy holidays too!

=IF(and('Stats Table'!$C$15<0, 'Stats Table'!$C$14-'Stats
Table'$C$15/'Stats Table'!$C$15 <1),'Stats Table'!$C$15+'Stats
Table!$C16*B15,"ver data!")

dribler2

"bearsfan" wrote:

I have data that I want to pull from a table but want to use a formula to
calculate the answer to allow for variance. In normal english the formula I
am trying to use is =If the Max-Average/Average is <1 then take the Average
and add 1/2 of the standard deviation. The formula below provides me with a
"False" answer instead of a number figure.

=IF 'Stats Table'!$C$15<0, IF ('Stats Table'!$C$14-'Stats
Table'$C$15/'Stats Table'!$C$15 <1, then 'Stats Table'!$C$15+'Stats
Table!$C16*B15)

Can someone please tell me what I am doing wrong with this formula? Thank
you for your help and happy holidays!

BearsFan

If you want this
Max-Average/Average is <1

which is what you have stated and Dribler has provided (and you say it works
great), then why not just use

Max -1 < 1

or
Max < 2

--
Regards,
Tom Ogilvy


"bearsfan" wrote in message
...
Thanks for the help folks! Dribler2, your forumula worked like a charm!



"dribler2" wrote:

happy holidays too!

=IF(and('Stats Table'!$C$15<0, 'Stats Table'!$C$14-'Stats
Table'$C$15/'Stats Table'!$C$15 <1),'Stats Table'!$C$15+'Stats
Table!$C16*B15,"ver data!")

dribler2

"bearsfan" wrote:

I have data that I want to pull from a table but want to use a formula
to
calculate the answer to allow for variance. In normal english the
formula I
am trying to use is =If the Max-Average/Average is <1 then take the
Average
and add 1/2 of the standard deviation. The formula below provides me
with a
"False" answer instead of a number figure.

=IF 'Stats Table'!$C$15<0, IF ('Stats Table'!$C$14-'Stats
Table'$C$15/'Stats Table'!$C$15 <1, then 'Stats Table'!$C$15+'Stats
Table!$C16*B15)

Can someone please tell me what I am doing wrong with this formula?
Thank
you for your help and happy holidays!

BearsFan