I am working on a spread sheet where I am calculating the percentage of
retail markdowns. I am using the formula below:

=SUM((H3-J3)/H3)

But, in some cases j will be empty, so I want it to use i instead. Is there
a formula I can use to make it use i if j is empty?

Thanks so much!

Try


=IF(J30,SUM((H3-J3)/H3),SUM((H3-I3)/H3))

Mike


"Michelle" wrote:

I am working on a spread sheet where I am calculating the percentage of
retail markdowns. I am using the formula below:

=SUM((H3-J3)/H3)

But, in some cases j will be empty, so I want it to use i instead. Is there
a formula I can use to make it use i if j is empty?

Thanks so much!

Try this:

=(H3-IF(J3="",I3,J3))/H3

Biff

"Michelle" wrote in message
...
I am working on a spread sheet where I am calculating the percentage of
retail markdowns. I am using the formula below:

=SUM((H3-J3)/H3)

But, in some cases j will be empty, so I want it to use i instead. Is
there
a formula I can use to make it use i if j is empty?

Thanks so much!

You might want to check for blank H3 as well since you will get an error if
H is blank

=(H3-IF(J3="",I3,J3))/H3

=IF(N(H3)=0,"",(H3-IF(J3="",I3,J3))/H3)



--
Regards,

Peo Sjoblom



"Michelle" wrote in message
...
I am working on a spread sheet where I am calculating the percentage of
retail markdowns. I am using the formula below:

=SUM((H3-J3)/H3)

But, in some cases j will be empty, so I want it to use i instead. Is
there
a formula I can use to make it use i if j is empty?

Thanks so much!

Thanks, Mike! You rock! It worked!


"Mike H" wrote:

Try


=IF(J30,SUM((H3-J3)/H3),SUM((H3-I3)/H3))

Mike


"Michelle" wrote:

I am working on a spread sheet where I am calculating the percentage of
retail markdowns. I am using the formula below:

=SUM((H3-J3)/H3)

But, in some cases j will be empty, so I want it to use i instead. Is there
a formula I can use to make it use i if j is empty?

Thanks so much!

Michelle,

I thought it might, thanks for the feedback. However you might like to read
your other posts because checking that J3 is a number is also a good idea.

Mike

"Michelle" wrote:

Thanks, Mike! You rock! It worked!


"Mike H" wrote:

Try


=IF(J30,SUM((H3-J3)/H3),SUM((H3-I3)/H3))

Mike


"Michelle" wrote:

I am working on a spread sheet where I am calculating the percentage of
retail markdowns. I am using the formula below:

=SUM((H3-J3)/H3)

But, in some cases j will be empty, so I want it to use i instead. Is there
a formula I can use to make it use i if j is empty?

Thanks so much!

No need for the SUM function in this case


--
Regards,

Peo Sjoblom



"Michelle" wrote in message
...
Thanks, Mike! You rock! It worked!


"Mike H" wrote:

Try


=IF(J30,SUM((H3-J3)/H3),SUM((H3-I3)/H3))

Mike


"Michelle" wrote:

I am working on a spread sheet where I am calculating the percentage of
retail markdowns. I am using the formula below:

=SUM((H3-J3)/H3)

But, in some cases j will be empty, so I want it to use i instead. Is
there
a formula I can use to make it use i if j is empty?

Thanks so much!

Thanks to all for respoding so quickly!! Much appreciated!

"Peo Sjoblom" wrote:

You might want to check for blank H3 as well since you will get an error if
H is blank

=(H3-IF(J3="",I3,J3))/H3

=IF(N(H3)=0,"",(H3-IF(J3="",I3,J3))/H3)



--
Regards,

Peo Sjoblom



"Michelle" wrote in message
...
I am working on a spread sheet where I am calculating the percentage of
retail markdowns. I am using the formula below:

=SUM((H3-J3)/H3)

But, in some cases j will be empty, so I want it to use i instead. Is
there
a formula I can use to make it use i if j is empty?

Thanks so much!