| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does worksheet require two different forms of same formulas
-- nothappy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why does worksheet require two different forms of same formulas
What do you mean?
-- Kind regards, Niek Otten Microsoft MVP - Excel "nothappy" wrote in message ... -- nothappy |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why does worksheet require two different forms of same formulas
i have a wosheet set up and I originally set the formula up as
=if(h5=250,if(h5<300,300,0)) in a column of 42 formulas. Sometimes the answer comes back correctly, with either 300 or o, but other times it comes back with "false" as the response. In order to get rid of the "false" response, I have to rewrite the formula as =(h5?=250,if(h5<300,300),0). I may receive the desired response for anumber of cells and the get the "false" response "nothappy" wrote: -- nothappy |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why does worksheet require two different forms of same formul
Hi,
You are occasionally getting FALSE because your formula is poorly constructed. =IF(H5=250,IF(H5<300,300,0)) If H5 is = 250 then this bit evaluates IF(H5<300,300,0)) In this part of the formula if H5 is < 300 you get 300 but if it's =300 you get zero returned. But it all goes pear shaped if H5 is <250 because nothing is included in the formula to evaluate so it returns FALSE A better constructed formula could be this but I've no odea what your trying to achieve. =IF(H5=250,IF(H5<300,300,0),"Some other output") Mike "nothappy" wrote: i have a wosheet set up and I originally set the formula up as =if(h5=250,if(h5<300,300,0)) in a column of 42 formulas. Sometimes the answer comes back correctly, with either 300 or o, but other times it comes back with "false" as the response. In order to get rid of the "false" response, I have to rewrite the formula as =(h5?=250,if(h5<300,300),0). I may receive the desired response for anumber of cells and the get the "false" response "nothappy" wrote: -- nothappy |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why does worksheet require two different forms of same formul
I am trying to determine if a value falls betwen 250 and 300 and if it does
return 300 as the answer, if it doesn't return 0 -- nothappy "Mike H" wrote: Hi, You are occasionally getting FALSE because your formula is poorly constructed. =IF(H5=250,IF(H5<300,300,0)) If H5 is = 250 then this bit evaluates IF(H5<300,300,0)) In this part of the formula if H5 is < 300 you get 300 but if it's =300 you get zero returned. But it all goes pear shaped if H5 is <250 because nothing is included in the formula to evaluate so it returns FALSE A better constructed formula could be this but I've no odea what your trying to achieve. =IF(H5=250,IF(H5<300,300,0),"Some other output") Mike "nothappy" wrote: i have a wosheet set up and I originally set the formula up as =if(h5=250,if(h5<300,300,0)) in a column of 42 formulas. Sometimes the answer comes back correctly, with either 300 or o, but other times it comes back with "false" as the response. In order to get rid of the "false" response, I have to rewrite the formula as =(h5?=250,if(h5<300,300),0). I may receive the desired response for anumber of cells and the get the "false" response "nothappy" wrote: -- nothappy |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why does worksheet require two different forms of same formul
Hi,
Try this way =IF(AND(H5=250,H5<=300),300,0) Mike "nothappy" wrote: I am trying to determine if a value falls betwen 250 and 300 and if it does return 300 as the answer, if it doesn't return 0 -- nothappy "Mike H" wrote: Hi, You are occasionally getting FALSE because your formula is poorly constructed. =IF(H5=250,IF(H5<300,300,0)) If H5 is = 250 then this bit evaluates IF(H5<300,300,0)) In this part of the formula if H5 is < 300 you get 300 but if it's =300 you get zero returned. But it all goes pear shaped if H5 is <250 because nothing is included in the formula to evaluate so it returns FALSE A better constructed formula could be this but I've no odea what your trying to achieve. =IF(H5=250,IF(H5<300,300,0),"Some other output") Mike "nothappy" wrote: i have a wosheet set up and I originally set the formula up as =if(h5=250,if(h5<300,300,0)) in a column of 42 formulas. Sometimes the answer comes back correctly, with either 300 or o, but other times it comes back with "false" as the response. In order to get rid of the "false" response, I have to rewrite the formula as =(h5?=250,if(h5<300,300),0). I may receive the desired response for anumber of cells and the get the "false" response "nothappy" wrote: -- nothappy |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why does worksheet require two different forms of same formul
Thanks Mike H. it works beautifully. I'm Happy now!
-- nothappy "Mike H" wrote: Hi, Try this way =IF(AND(H5=250,H5<=300),300,0) Mike "nothappy" wrote: I am trying to determine if a value falls betwen 250 and 300 and if it does return 300 as the answer, if it doesn't return 0 -- nothappy "Mike H" wrote: Hi, You are occasionally getting FALSE because your formula is poorly constructed. =IF(H5=250,IF(H5<300,300,0)) If H5 is = 250 then this bit evaluates IF(H5<300,300,0)) In this part of the formula if H5 is < 300 you get 300 but if it's =300 you get zero returned. But it all goes pear shaped if H5 is <250 because nothing is included in the formula to evaluate so it returns FALSE A better constructed formula could be this but I've no odea what your trying to achieve. =IF(H5=250,IF(H5<300,300,0),"Some other output") Mike "nothappy" wrote: i have a wosheet set up and I originally set the formula up as =if(h5=250,if(h5<300,300,0)) in a column of 42 formulas. Sometimes the answer comes back correctly, with either 300 or o, but other times it comes back with "false" as the response. In order to get rid of the "false" response, I have to rewrite the formula as =(h5?=250,if(h5<300,300),0). I may receive the desired response for anumber of cells and the get the "false" response "nothappy" wrote: -- nothappy |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why does worksheet require two different forms of same formul
Try this:
=(H5=250)*(H5<300)*300 "nothappy" wrote: I am trying to determine if a value falls betwen 250 and 300 and if it does return 300 as the answer, if it doesn't return 0 -- nothappy "Mike H" wrote: Hi, You are occasionally getting FALSE because your formula is poorly constructed. =IF(H5=250,IF(H5<300,300,0)) If H5 is = 250 then this bit evaluates IF(H5<300,300,0)) In this part of the formula if H5 is < 300 you get 300 but if it's =300 you get zero returned. But it all goes pear shaped if H5 is <250 because nothing is included in the formula to evaluate so it returns FALSE A better constructed formula could be this but I've no odea what your trying to achieve. =IF(H5=250,IF(H5<300,300,0),"Some other output") Mike "nothappy" wrote: i have a wosheet set up and I originally set the formula up as =if(h5=250,if(h5<300,300,0)) in a column of 42 formulas. Sometimes the answer comes back correctly, with either 300 or o, but other times it comes back with "false" as the response. In order to get rid of the "false" response, I have to rewrite the formula as =(h5?=250,if(h5<300,300),0). I may receive the desired response for anumber of cells and the get the "false" response "nothappy" wrote: -- nothappy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I would require help in inserting formulas in Pivot Table please. | Excel Discussion (Misc queries) | |||
| Forms toolbar Worksheet | Excel Discussion (Misc queries) | |||
| Use of Forms Command-button on Worksheet | Excel Discussion (Misc queries) | |||
| formulas/function require (2) | Excel Worksheet Functions | |||
| Delete Forms CommandButton on Worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
