| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple conditions for one function
I want a function to occur when a value in one cell is greater than 0 and
when it equals zero. However when the cell is blank i do not want the function to occur or for there to be anything visible in the cell. Right now it is treating a blank cell as zero. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple conditions for one function
Hi,
Following should help ... =IF(AND(A1=0,A1<""),"YES","") HTH |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple conditions for one function
With
A1: (a number, zero, or blank) Try this: =IF(A1="","",IF(A1,"your < zero formula","your = zero formula")) Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Minnie2627" wrote in message ... I want a function to occur when a value in one cell is greater than 0 and when it equals zero. However when the cell is blank i do not want the function to occur or for there to be anything visible in the cell. Right now it is treating a blank cell as zero. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple conditions for one function
=if(a1=0;function;"")
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Minnie2627" escreveu: I want a function to occur when a value in one cell is greater than 0 and when it equals zero. However when the cell is blank i do not want the function to occur or for there to be anything visible in the cell. Right now it is treating a blank cell as zero. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple conditions for one function
And how does that treat a blank cell, Marcelo?
-- David Biddulph "Marcelo" wrote in message ... =if(a1=0;function;"") hth "Minnie2627" escreveu: I want a function to occur when a value in one cell is greater than 0 and when it equals zero. However when the cell is blank i do not want the function to occur or for there to be anything visible in the cell. Right now it is treating a blank cell as zero. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple conditions for one function
yes you are right, I lost some part of the question.
sorry for the mistake -- regards from Brazil Thanks in advance for your feedback. Marcelo "David Biddulph" escreveu: And how does that treat a blank cell, Marcelo? -- David Biddulph "Marcelo" wrote in message ... =if(a1=0;function;"") hth "Minnie2627" escreveu: I want a function to occur when a value in one cell is greater than 0 and when it equals zero. However when the cell is blank i do not want the function to occur or for there to be anything visible in the cell. Right now it is treating a blank cell as zero. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple conditions for one function
=IF(AND(A2<"",A2=0),"whatever you want","")
-- David Biddulph "Minnie2627" wrote in message ... I want a function to occur when a value in one cell is greater than 0 and when it equals zero. However when the cell is blank i do not want the function to occur or for there to be anything visible in the cell. Right now it is treating a blank cell as zero. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple conditions with IF function. | Excel Worksheet Functions | |||
| Multiple Conditions within an IF Function | Excel Worksheet Functions | |||
| If Function with Multiple Conditions | Excel Discussion (Misc queries) | |||
| Logiacl function with multiple conditions | Excel Worksheet Functions | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Hybrid Mode
