| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then
I need a formula for cell B1.
If cell A1 is greater than 0 enter that value in b1. I will be using this formula to teach myself the basics of if then formulas -- bob |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then
Look in the help index for IF -- Don Guillett Microsoft MVP Excel SalesAid Software "vdmbqb" wrote in message ... I need a formula for cell B1. If cell A1 is greater than 0 enter that value in b1. I will be using this formula to teach myself the basics of if then formulas -- bob |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then
=IF(A10,1,"")
This will return 1 if the value in A1 is greater than 0 and Blank if it is not greater than 0. "vdmbqb" wrote in message ... I need a formula for cell B1. If cell A1 is greater than 0 enter that value in b1. I will be using this formula to teach myself the basics of if then formulas -- bob |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then
Oh I guess you want same value to be ruturned. use =IF(A10,A1,"")
"Gaurav" wrote in message ... =IF(A10,1,"") This will return 1 if the value in A1 is greater than 0 and Blank if it is not greater than 0. "vdmbqb" wrote in message ... I need a formula for cell B1. If cell A1 is greater than 0 enter that value in b1. I will be using this formula to teach myself the basics of if then formulas -- bob |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then
Your formula will fail if A1 contain text
Here is the correction: =IF(AND(ISNUMBER(A1),A10),A1,"") "Gaurav" wrote: Oh I guess you want same value to be ruturned. use =IF(A10,A1,"") "Gaurav" wrote in message ... =IF(A10,1,"") This will return 1 if the value in A1 is greater than 0 and Blank if it is not greater than 0. "vdmbqb" wrote in message ... I need a formula for cell B1. If cell A1 is greater than 0 enter that value in b1. I will be using this formula to teach myself the basics of if then formulas -- bob |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if then
This also seems to work...
=IF(MAX(A1,0)0,A1,"") Rick "Teethless mama" wrote in message ... Your formula will fail if A1 contain text Here is the correction: =IF(AND(ISNUMBER(A1),A10),A1,"") "Gaurav" wrote: Oh I guess you want same value to be ruturned. use =IF(A10,A1,"") "Gaurav" wrote in message ... =IF(A10,1,"") This will return 1 if the value in A1 is greater than 0 and Blank if it is not greater than 0. "vdmbqb" wrote in message ... I need a formula for cell B1. If cell A1 is greater than 0 enter that value in b1. I will be using this formula to teach myself the basics of if then formulas -- bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
