Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula question
I need help with three formulas. if anyone can help.
formula 1 Need a formula that says, if a cell in sheet1 has number greater than 0, then put Yes in sheet2 otherwise null formula 2 Need a formula that says if field is a, then put b, else carry data in a column Ei: A B C C D D A B formula 3 Need a formula that says if cell = boat, then go to sheet2 and pull data. thanks, JaneS |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula question
=IF(Sheet1!A10,"Yes","")
=IF(A1="A","B",A1) Don't know what you mean with the 3rd replace A1 with the cell(s) in question -- Regards, Peo Sjoblom "JaneSmith" wrote in message ... I need help with three formulas. if anyone can help. formula 1 Need a formula that says, if a cell in sheet1 has number greater than 0, then put "Yes" in sheet2 otherwise null formula 2 Need a formula that says if field is a, then put b, else carry data in a column Ei: A B C C D D A B formula 3 Need a formula that says if cell = boat, then go to sheet2 and pull data. thanks, JaneS |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula question
formula 3 Need a formula that says if cell = boat, then go to sheet2 and pull data. thanks, JaneS I also don't know exactly what you mean, but I assume something like this: =IF(A1="boat",Sheet2!A1,"") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question | Excel Worksheet Functions | |||
Formula question | Excel Discussion (Misc queries) | |||
what IF - formula question | Excel Worksheet Functions | |||
What IF - formula question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) |