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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a value from a different cell be the false answer in =If quest
Try the following:
=IF(ISBLANK(E6),"",E6) -- Kevin Backmann "Jenna" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a value from a different cell be the false answer in =If q
Sorry, I should have been more clear.
E6 will actually say "Not Given" or have a phone number in it. It will not be blank if nothing is given. Is there a way to do this? "Kevin B" wrote: Try the following: =IF(ISBLANK(E6),"",E6) -- Kevin Backmann "Jenna" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a value from a different cell be the false answer in =If q
Sorr, I shoul dhave been more clear.
E6 will actually say "not given" or have a phone number in it. It will not be blank. thanks "Kevin B" wrote: Try the following: =IF(ISBLANK(E6),"",E6) -- Kevin Backmann "Jenna" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a value from a different cell be the false answer in =If quest
=IF(ISBLANK(E6),"Not Given",E6) If you have another column where a phone number might be you could write: =IF(ISBLANK(E6),IF(ISBLANK(F6),"Not Given",F6),E6) Where F6 represents the cell where you might or might not have a phone number. Peter -- Peter1999 ------------------------------------------------------------------------ Peter1999's Profile: http://www.excelforum.com/member.php...o&userid=33997 View this thread: http://www.excelforum.com/showthread...hreadid=549045 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a value from a different cell be the false answer in =If q
"Jenna" wrote in message
... "Kevin B" wrote: "Jenna" wrote: 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 Try the following: =IF(ISBLANK(E6),"",E6) Sorry, I should have been more clear. E6 will actually say "Not Given" or have a phone number in it. It will not be blank if nothing is given. Is there a way to do this? =IF(E6="Not Given","", E6) -- David Biddulph |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a value from a different cell be the false answer in =If q
But E6 won't be blank. it will either have a phone number in it or say "not
given" "Peter1999" wrote: =IF(ISBLANK(E6),"Not Given",E6) If you have another column where a phone number might be you could write: =IF(ISBLANK(E6),IF(ISBLANK(F6),"Not Given",F6),E6) Where F6 represents the cell where you might or might not have a phone number. Peter -- Peter1999 ------------------------------------------------------------------------ Peter1999's Profile: http://www.excelforum.com/member.php...o&userid=33997 View this thread: http://www.excelforum.com/showthread...hreadid=549045 |
Reply |
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) |