| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Vavle base on statement
I have a spread sheet and in B1 is a number that is populated from a Vlookup
table and in C1 is 0 in this cell the user can change the number if they don't agree on the number in B1. In D1 the number for B!. What I need help with is if the number in C1 is grater then 0 return it to D1 if the number is 0 then return B1 Thanks for the help Larry |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return Vavle base on statement
Maybe this in d1
=IF(C10,C1,B1) Mike "Larry" wrote: I have a spread sheet and in B1 is a number that is populated from a Vlookup table and in C1 is 0 in this cell the user can change the number if they don't agree on the number in B1. In D1 the number for B!. What I need help with is if the number in C1 is grater then 0 return it to D1 if the number is 0 then return B1 Thanks for the help Larry |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return Vavle base on statement
Mike thanks for the help it work great.
"Mike H" wrote: Maybe this in d1 =IF(C10,C1,B1) Mike "Larry" wrote: I have a spread sheet and in B1 is a number that is populated from a Vlookup table and in C1 is 0 in this cell the user can change the number if they don't agree on the number in B1. In D1 the number for B!. What I need help with is if the number in C1 is grater then 0 return it to D1 if the number is 0 then return B1 Thanks for the help Larry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using error type and if statement to return a value. | Excel Worksheet Functions | |||
| Vlookup to return results of If statement | Excel Worksheet Functions | |||
| Return Excel IF statement to a different worksheet? | Excel Discussion (Misc queries) | |||
| Return range of values on an "IF" statement | Excel Worksheet Functions | |||
| Vlookup of an if statement return | Excel Worksheet Functions | |||
Linear Mode
