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!

check your other post

"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!

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"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, guys, I appreciate your help!

Mike, I posted here b/c I thought I posted in the wrong place, sorry for the
double post!

"Bob Phillips" wrote:

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"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!