Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a value from a different cell be the false answer in =If quest
I want to write an If statement where if the answer is false, the exact value
from another cell will go into the cell with the formula. For example. In H6 i would write =If(E6=not given, "", "E6") where if E6 = not given nothing would appear in H6, but if it did NOT = not given then the value in E6 would go into H6 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How do I multiply 1 cell x 1 cell and answer in 3rd cell? | Excel Worksheet Functions | |||
Shorten a Macro | Excel Discussion (Misc queries) |