Conditional Formulas
 

I am trying to do the following:

I have entered a formula in which the results must be greater than or equal
to 5. If it is less than 5 I want the cell to have a "5" and if it is
greater or equal to 5 I would like the actual result of the equation to be
displayed. This is what I have so far:

=IF(D8/(60*I8)<5, 5, (D8/60*I8))

This isn't working out for me. I know I could have the formula calculate
the result in one cell and place my "IF" statement in another, but I am
trying to condense my already complicated spreadsheet. Any and all
suggestions are appreciated! =)

Conditional Formulas
 

=max(5,your formula) - would simply things a bit.
--
Wag more, bark less


"Tonia" wrote:

I am trying to do the following:

I have entered a formula in which the results must be greater than or equal
to 5. If it is less than 5 I want the cell to have a "5" and if it is
greater or equal to 5 I would like the actual result of the equation to be
displayed. This is what I have so far:

=IF(D8/(60*I8)<5, 5, (D8/60*I8))

This isn't working out for me. I know I could have the formula calculate
the result in one cell and place my "IF" statement in another, but I am
trying to condense my already complicated spreadsheet. Any and all
suggestions are appreciated! =)

Conditional Formulas
 

Thanks!

"Brad" wrote:

=max(5,your formula) - would simply things a bit.
--
Wag more, bark less


"Tonia" wrote:

I am trying to do the following:

I have entered a formula in which the results must be greater than or equal
to 5. If it is less than 5 I want the cell to have a "5" and if it is
greater or equal to 5 I would like the actual result of the equation to be
displayed. This is what I have so far:

=IF(D8/(60*I8)<5, 5, (D8/60*I8))

This isn't working out for me. I know I could have the formula calculate
the result in one cell and place my "IF" statement in another, but I am
trying to condense my already complicated spreadsheet. Any and all
suggestions are appreciated! =)

Conditional Formulas
 

You're welcome
--
Wag more, bark less


"Tonia" wrote:

Thanks!

"Brad" wrote:

=max(5,your formula) - would simply things a bit.
--
Wag more, bark less


"Tonia" wrote:

I am trying to do the following:

I have entered a formula in which the results must be greater than or equal
to 5. If it is less than 5 I want the cell to have a "5" and if it is
greater or equal to 5 I would like the actual result of the equation to be
displayed. This is what I have so far:

=IF(D8/(60*I8)<5, 5, (D8/60*I8))

This isn't working out for me. I know I could have the formula calculate
the result in one cell and place my "IF" statement in another, but I am
trying to condense my already complicated spreadsheet. Any and all
suggestions are appreciated! =)

Conditional Formulas
 

Presumably the reason that it isn't working is that D8/(60*I8) is not the
same as D8/60*I8
As other folk have suggested, MAX would be a good idea, once you've decided
which of the above you want.
--
David Biddulph

"Tonia" wrote in message
...
I am trying to do the following:

I have entered a formula in which the results must be greater than or
equal
to 5. If it is less than 5 I want the cell to have a "5" and if it is
greater or equal to 5 I would like the actual result of the equation to be
displayed. This is what I have so far:

=IF(D8/(60*I8)<5, 5, (D8/60*I8))

This isn't working out for me. I know I could have the formula calculate
the result in one cell and place my "IF" statement in another, but I am
trying to condense my already complicated spreadsheet. Any and all
suggestions are appreciated! =)