Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem I need Help With -- IF Statments
Have a spreadsheet that I need some help with. The spreadsheet has 5 columns
(a,b,c,d,and e). What I need to do is if there is a number entered in a,b,or c then e needs to =d. If there is no number the cell remains blank. Have tinkered with this a number of ways and not finding a good solution. Ideas? Appreicate the help. -- debra |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem I need Help With -- IF Statments
Give this a try. This formula goes in cell E1...
=IF(OR(ISNUMBER(A1), ISNUMBER(B1), ISNUMBER(C1)),D1, "") -- HTH... Jim Thomlinson "debra" wrote: Have a spreadsheet that I need some help with. The spreadsheet has 5 columns (a,b,c,d,and e). What I need to do is if there is a number entered in a,b,or c then e needs to =d. If there is no number the cell remains blank. Have tinkered with this a number of ways and not finding a good solution. Ideas? Appreicate the help. -- debra |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem I need Help With -- IF Statments
I'm not sure if this is the cleanest way, but you can try the following
formula in cell E1: =IF(OR(COUNT(A1)<0,COUNT(B1)<0,COUNT(C1)<0),D1, "") I'm using the COUNT() function to look for numbers by setting it not equal to zero, so it will ignore any non-numbers. If any of the columns a, b, or c has a number in it, column e will return whatever is in d, otherwise it will leave it blank. "debra" wrote: Have a spreadsheet that I need some help with. The spreadsheet has 5 columns (a,b,c,d,and e). What I need to do is if there is a number entered in a,b,or c then e needs to =d. If there is no number the cell remains blank. Have tinkered with this a number of ways and not finding a good solution. Ideas? Appreicate the help. -- debra |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem I need Help With -- IF Statments
In E2 put the formula =IF(OR(ISNUMBER(A2),ISNUMBER(B2),ISNUMBER(C2)),D2, "")
-- David Biddulph "debra" wrote in message ... Have a spreadsheet that I need some help with. The spreadsheet has 5 columns (a,b,c,d,and e). What I need to do is if there is a number entered in a,b,or c then e needs to =d. If there is no number the cell remains blank. Have tinkered with this a number of ways and not finding a good solution. Ideas? Appreicate the help. -- debra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
under standing if statments | Excel Worksheet Functions | |||
AND OR IF Statments | Excel Worksheet Functions | |||
IF statments and ranges | Excel Worksheet Functions | |||
If Statments containing letters | Excel Discussion (Misc queries) | |||
Conditional statments. | Excel Discussion (Misc queries) |