Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula that takes a range of values into consideration | Excel Discussion (Misc queries) | |||
Tab to next cell takes me 5 rows away!! | Excel Discussion (Misc queries) | |||
I NEED A FORMULA THAT TAKES THE DATE AND CONVERT IT IN A QUARTER | Excel Worksheet Functions | |||
formula that takes part of a cells contents to another | Excel Programming | |||
What takes the place of a space in a formula? | Excel Discussion (Misc queries) |