Only calculate a cell when both cells contain a value

[Losguapos1]

I have sheet where percent change is calculated. All of the data isn't put in at once, so i don't want it to a calculate the percent change until both cells contain a number.

Here is the formula i am using: =IFERROR((D4-B4)/B4,"")

Is there a way to do this?

Right now when i fill in the first value it automatically returns a percent change of -100%, i want it to wait until both cells are filled with data.

Thanks in avance

Los

[protonLeah]

=if(count(b4,d4)=2,(d4-b4)/b4,"")

[Richard Buttrey]

Hi,

One way

Please Login or Register  to view this content.

[Losguapos1]

that works but i also don't want to lose the if error part, if the donimator is zero i want it to also return a blank....

is this possible?

Los

[Richard Buttrey]

Hi,

OK, instead

Please Login or Register  to view this content.

[Losguapos1]

that works !!!!!

thank you and repped

Los