| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
showing a cell when it is not blank and ignoring it if it is
Hi
I would like A3 in my spreadsheet to show the value of A2 if the value of A1 is greater than 50. So A1 =67 A2= 340 A3= 340 or A1=0 A2=340 A3=0 Sometimes A1 and A2 will be blank so i would like A3 to return blank and not as False as i get so far on my own efforts! Many Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
showing a cell when it is not blank and ignoring it if it is
Maybe in A3
=IF(A150,A2,0) Mike "Neil" wrote: Hi I would like A3 in my spreadsheet to show the value of A2 if the value of A1 is greater than 50. So A1 =67 A2= 340 A3= 340 or A1=0 A2=340 A3=0 Sometimes A1 and A2 will be blank so i would like A3 to return blank and not as False as i get so far on my own efforts! Many Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
showing a cell when it is not blank and ignoring it if it is
=IF(OR(ISBLANK(A1),ISBLANK(A2)),"",IF(A150,A2,0))
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Neil" wrote in message ... Hi I would like A3 in my spreadsheet to show the value of A2 if the value of A1 is greater than 50. So A1 =67 A2= 340 A3= 340 or A1=0 A2=340 A3=0 Sometimes A1 and A2 will be blank so i would like A3 to return blank and not as False as i get so far on my own efforts! Many Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignoring blank cells | Excel Discussion (Misc queries) | |||
| How to have cell values of 0 showing as blank | Excel Worksheet Functions | |||
| Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
| Ignoring Blank Cells | Excel Worksheet Functions | |||
| Help with ignoring blank cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
