ExcelBanter - Return Vavle base on statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Return Vavle base on statement (https://www.excelbanter.com/excel-worksheet-functions/208458-return-vavle-base-statement.html)

Larry

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

Mike H

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

Larry

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

All times are GMT +1. The time now is 05:55 AM.