Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with and "IF" statement - ASAP
Hello, I need to write an IF statement. Basically, I want cell A21 = D4 *-if-* a value is present in it. If D4 is blank, then A21 should = D7. How would I set this up? -- iasiddiqui ------------------------------------------------------------------------ iasiddiqui's Profile: http://www.excelforum.com/member.php...o&userid=37543 View this thread: http://www.excelforum.com/showthread...hreadid=571803 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with and "IF" statement - ASAP
iasiddiqui Wrote: Hello, I need to write an IF statement. Basically, I want cell A21 = D4 *-if-* a value is present in it. If D4 is blank, then A21 should = D7. How would I set this up? Hi iasiddiqui, Try this, =IF(D40,D4,D7) oldchippy :) Sorry try this instead =IF(D4=ISBLANK(D4),D4,D7) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=571803 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with and "IF" statement - ASAP
=IF(D4<"",A21,D7)
"iasiddiqui" wrote: Hello, I need to write an IF statement. Basically, I want cell A21 = D4 *-if-* a value is present in it. If D4 is blank, then A21 should = D7. How would I set this up? -- iasiddiqui ------------------------------------------------------------------------ iasiddiqui's Profile: http://www.excelforum.com/member.php...o&userid=37543 View this thread: http://www.excelforum.com/showthread...hreadid=571803 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with and "IF" statement - ASAP
...oops ...
=IF(D4<"",D4,D7) "Toppers" wrote: =IF(D4<"",A21,D7) "iasiddiqui" wrote: Hello, I need to write an IF statement. Basically, I want cell A21 = D4 *-if-* a value is present in it. If D4 is blank, then A21 should = D7. How would I set this up? -- iasiddiqui ------------------------------------------------------------------------ iasiddiqui's Profile: http://www.excelforum.com/member.php...o&userid=37543 View this thread: http://www.excelforum.com/showthread...hreadid=571803 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with and "IF" statement - ASAP
no, neither is working -- iasiddiqui ------------------------------------------------------------------------ iasiddiqui's Profile: http://www.excelforum.com/member.php...o&userid=37543 View this thread: http://www.excelforum.com/showthread...hreadid=571803 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with and "IF" statement - ASAP
let me clarify: A21 = D4 only if D4 contains a value. If D4 is blank, then A21 = D7. -- iasiddiqui ------------------------------------------------------------------------ iasiddiqui's Profile: http://www.excelforum.com/member.php...o&userid=37543 View this thread: http://www.excelforum.com/showthread...hreadid=571803 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with and "IF" statement - ASAP
thank you very much, that worked!!! -- iasiddiqui ------------------------------------------------------------------------ iasiddiqui's Profile: http://www.excelforum.com/member.php...o&userid=37543 View this thread: http://www.excelforum.com/showthread...hreadid=571803 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use "In" in an "If" statement? | Excel Discussion (Misc queries) | |||
"IF" statement & "strikethrough" formatting | Excel Worksheet Functions | |||
"IF" "AND" Statement | Excel Discussion (Misc queries) | |||
help needed with "if" statement | Excel Worksheet Functions | |||
"If" statement using "And" | Excel Discussion (Misc queries) |