Formula that takes a cell value over another?
 

Currently, I have formulas in various cells that looks like this:

=IF($A$2<"",($E$8-$F$7),"")

F7 ($F$7) has a calculation based on a percentage. I've run into the
difficulty is that I need to decide in some cases to not use that
calculation and to have an adjusted value instead.

Is there a way to have the above formula take the value of F7 only if, say,
F8 (a cell we can put a value into) is empty? So, to explain it another
way, if F8 has a value the user has put in, the formula subtracts that
instead?

Tx.

Formula that takes a cell value over another?
 

=IF($A$2<"",If($F$8="",($E$8-$F$7),""),"")
--
Charles Chickering

"A good example is twice the value of good advice."


"StargateFanFromWork" wrote:

Currently, I have formulas in various cells that looks like this:

=IF($A$2<"",($E$8-$F$7),"")

F7 ($F$7) has a calculation based on a percentage. I've run into the
difficulty is that I need to decide in some cases to not use that
calculation and to have an adjusted value instead.

Is there a way to have the above formula take the value of F7 only if, say,
F8 (a cell we can put a value into) is empty? So, to explain it another
way, if F8 has a value the user has put in, the formula subtracts that
instead?

Tx.

Formula that takes a cell value over another?
 

Oops, forgot to handle F8 having data...
=IF($A$2<"",If($F$8="",($E$8-$F$7),($E$8-$F$8)),"")
--
Charles Chickering

"A good example is twice the value of good advice."


"Charles Chickering" wrote:

=IF($A$2<"",If($F$8="",($E$8-$F$7),""),"")
--
Charles Chickering

"A good example is twice the value of good advice."


"StargateFanFromWork" wrote:

Currently, I have formulas in various cells that looks like this:

=IF($A$2<"",($E$8-$F$7),"")

F7 ($F$7) has a calculation based on a percentage. I've run into the
difficulty is that I need to decide in some cases to not use that
calculation and to have an adjusted value instead.

Is there a way to have the above formula take the value of F7 only if, say,
F8 (a cell we can put a value into) is empty? So, to explain it another
way, if F8 has a value the user has put in, the formula subtracts that
instead?

Tx.

Formula that takes a cell value over another?
 

"Charles Chickering" wrote in
message ...
=IF($A$2<"",If($F$8="",($E$8-$F$7),""),"")

Hmmm, sorry, I seem to have explained something incorrectly, my fault. Now
when I put a value into the new cell, E8, the results blank out completely.

The code of =IF($A$2<"",($D$9-$F$7),"")
works fine (sorry, my bad again. I should have added the extra row so that
I'd get a cell I could input into (E8) rather than just doing it in my head.
The spreadshseet is now corrected and show the change in the default cell
name of $D$9).

If I input something into E8, I need the formula to take that value rather
than the value that is currently in E7. There won't always be a value in
E8, but we need to have the ability to input something there in case we need
to make a manual adjustment.

Thanks and hope I didn't mess things up again here. <g

--
Charles Chickering

"A good example is twice the value of good advice."


"StargateFanFromWork" wrote:

Currently, I have formulas in various cells that looks like this:

=IF($A$2<"",($E$8-$F$7),"")

F7 ($F$7) has a calculation based on a percentage. I've run into the
difficulty is that I need to decide in some cases to not use that
calculation and to have an adjusted value instead.

Is there a way to have the above formula take the value of F7 only if,
say,
F8 (a cell we can put a value into) is empty? So, to explain it another
way, if F8 has a value the user has put in, the formula subtracts that
instead?

Tx.

Formula that takes a cell value over another?
 

Yes, that was my fault, see my second post as I fixed the issue:

Oops, forgot to handle F8 having data...
=IF($A$2<"",If($F$8="",($E$8-$F$7),($E$8-$F$8)),"")

--
Charles Chickering

"A good example is twice the value of good advice."


"StargateFanFromWork" wrote:

"Charles Chickering" wrote in
message ...
=IF($A$2<"",If($F$8="",($E$8-$F$7),""),"")

Hmmm, sorry, I seem to have explained something incorrectly, my fault. Now
when I put a value into the new cell, E8, the results blank out completely.

The code of =IF($A$2<"",($D$9-$F$7),"")
works fine (sorry, my bad again. I should have added the extra row so that
I'd get a cell I could input into (E8) rather than just doing it in my head.
The spreadshseet is now corrected and show the change in the default cell
name of $D$9).

If I input something into E8, I need the formula to take that value rather
than the value that is currently in E7. There won't always be a value in
E8, but we need to have the ability to input something there in case we need
to make a manual adjustment.

Thanks and hope I didn't mess things up again here. <g

--
Charles Chickering

"A good example is twice the value of good advice."


"StargateFanFromWork" wrote:

Currently, I have formulas in various cells that looks like this:

=IF($A$2<"",($E$8-$F$7),"")

F7 ($F$7) has a calculation based on a percentage. I've run into the
difficulty is that I need to decide in some cases to not use that
calculation and to have an adjusted value instead.

Is there a way to have the above formula take the value of F7 only if,
say,
F8 (a cell we can put a value into) is empty? So, to explain it another
way, if F8 has a value the user has put in, the formula subtracts that
instead?

Tx.

Formula that takes a cell value over another?
 

Ah, great!! That did the trick.

I adjusted to this (due to cell name change) and it works perfectly:
=IF($A$2<"",IF($E$8="",($D$9-$E$7),($D$9-$E$8)),"")

Thanks!!! :oD

"Charles Chickering" wrote in
message ...
Oops, forgot to handle F8 having data...
=IF($A$2<"",If($F$8="",($E$8-$F$7),($E$8-$F$8)),"")
--
Charles Chickering

"A good example is twice the value of good advice."


"Charles Chickering" wrote:

=IF($A$2<"",If($F$8="",($E$8-$F$7),""),"")
--
Charles Chickering

"A good example is twice the value of good advice."


"StargateFanFromWork" wrote:

Currently, I have formulas in various cells that looks like this:

=IF($A$2<"",($E$8-$F$7),"")

F7 ($F$7) has a calculation based on a percentage. I've run into the
difficulty is that I need to decide in some cases to not use that
calculation and to have an adjusted value instead.

Is there a way to have the above formula take the value of F7 only if,
say,
F8 (a cell we can put a value into) is empty? So, to explain it
another
way, if F8 has a value the user has put in, the formula subtracts that
instead?

Tx.

Formula that takes a cell value over another?
 

Thanks! Yes, saw your second post only _after_ sending my response <g.

It's working perfectly now, thanks so much!! :oD

"Charles Chickering" wrote in
message ...
Yes, that was my fault, see my second post as I fixed the issue:

Oops, forgot to handle F8 having data...
=IF($A$2<"",If($F$8="",($E$8-$F$7),($E$8-$F$8)),"")

--
Charles Chickering

"A good example is twice the value of good advice."


"StargateFanFromWork" wrote:

"Charles Chickering" wrote
in
message ...
=IF($A$2<"",If($F$8="",($E$8-$F$7),""),"")

Hmmm, sorry, I seem to have explained something incorrectly, my fault.
Now
when I put a value into the new cell, E8, the results blank out
completely.

The code of =IF($A$2<"",($D$9-$F$7),"")
works fine (sorry, my bad again. I should have added the extra row so
that
I'd get a cell I could input into (E8) rather than just doing it in my
head.
The spreadshseet is now corrected and show the change in the default
cell
name of $D$9).

If I input something into E8, I need the formula to take that value
rather
than the value that is currently in E7. There won't always be a value
in
E8, but we need to have the ability to input something there in case we
need
to make a manual adjustment.

Thanks and hope I didn't mess things up again here. <g

--
Charles Chickering

"A good example is twice the value of good advice."


"StargateFanFromWork" wrote:

Currently, I have formulas in various cells that looks like this:

=IF($A$2<"",($E$8-$F$7),"")

F7 ($F$7) has a calculation based on a percentage. I've run into
the
difficulty is that I need to decide in some cases to not use that
calculation and to have an adjusted value instead.

Is there a way to have the above formula take the value of F7 only
if,
say,
F8 (a cell we can put a value into) is empty? So, to explain it
another
way, if F8 has a value the user has put in, the formula subtracts
that
instead?

Tx.