Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
complicated formula
I need help. I have a number in a cell. I want the formula to be the
following but i don't know how to write it or if it is possible. If the value in Z10 is less than zero, then i want it to pull back the phrase "no order". If this is not the case---if it is positive, then I want it to look at X10....if X10 is negative, then I want the result to be (AI10-AJ10) + AS10. If X10 is positive, then I want the result to be AS10. Can someone please help me?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
complicated formula
Not complicated but there are some holes in your post
=IF(Z10<0,"no order",IF(X10<0,AI10-AJ10,AS10)) what if Z10 or X10 are blank or 0? -- Regards, Peo Sjoblom "Joann" wrote in message ... I need help. I have a number in a cell. I want the formula to be the following but i don't know how to write it or if it is possible. If the value in Z10 is less than zero, then i want it to pull back the phrase "no order". If this is not the case---if it is positive, then I want it to look at X10....if X10 is negative, then I want the result to be (AI10-AJ10) + AS10. If X10 is positive, then I want the result to be AS10. Can someone please help me?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
complicated formula
Try:
=IF(Z10<=0,"No Order",IF(X10<=0,AI10-AJ10+AS10,AS10)) or the slightly shorter: =IF(Z10<=0,"No Order",AS10+(AI10-AJ10)*(X10<=0)) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Joann" wrote in message ... I need help. I have a number in a cell. I want the formula to be the following but i don't know how to write it or if it is possible. If the value in Z10 is less than zero, then i want it to pull back the phrase "no order". If this is not the case---if it is positive, then I want it to look at X10....if X10 is negative, then I want the result to be (AI10-AJ10) + AS10. If X10 is positive, then I want the result to be AS10. Can someone please help me?? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
complicated formula
Well, I don't think that will happen....given the data that I have, I don't
see anywhere in which that is the case....I am dealing with order quantities & it will always be either positive or negative...can you help? "Peo Sjoblom" wrote: Not complicated but there are some holes in your post =IF(Z10<0,"no order",IF(X10<0,AI10-AJ10,AS10)) what if Z10 or X10 are blank or 0? -- Regards, Peo Sjoblom "Joann" wrote in message ... I need help. I have a number in a cell. I want the formula to be the following but i don't know how to write it or if it is possible. If the value in Z10 is less than zero, then i want it to pull back the phrase "no order". If this is not the case---if it is positive, then I want it to look at X10....if X10 is negative, then I want the result to be (AI10-AJ10) + AS10. If X10 is positive, then I want the result to be AS10. Can someone please help me?? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
complicated formula
ok, here is where I am....I have the fomula listed below.....
=IF(AC16<0,"NO ORDER",IF(AB16<0,AJ16-AK16+AT16+AU16,AU16)) AB is the column in which the result is either positive or no order. So in this calculation, instead of calculating the equasion out AJ16-AK16+AT16+AU16, it is just bringing back AU16....does that result of no order have to do with this doing this? "Peo Sjoblom" wrote: Not complicated but there are some holes in your post =IF(Z10<0,"no order",IF(X10<0,AI10-AJ10,AS10)) what if Z10 or X10 are blank or 0? -- Regards, Peo Sjoblom "Joann" wrote in message ... I need help. I have a number in a cell. I want the formula to be the following but i don't know how to write it or if it is possible. If the value in Z10 is less than zero, then i want it to pull back the phrase "no order". If this is not the case---if it is positive, then I want it to look at X10....if X10 is negative, then I want the result to be (AI10-AJ10) + AS10. If X10 is positive, then I want the result to be AS10. Can someone please help me?? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
complicated formula
I think this works - but depends on how you want to treat a zero. Formula
below assumes a negative number is classed as something less than zero Hope this helps. =IF(Z10<0,"No Order",IF(X10<0,AI10-AJ10+AS10,AS10)) "Joann" wrote in message ... I need help. I have a number in a cell. I want the formula to be the following but i don't know how to write it or if it is possible. If the value in Z10 is less than zero, then i want it to pull back the phrase "no order". If this is not the case---if it is positive, then I want it to look at X10....if X10 is negative, then I want the result to be (AI10-AJ10) + AS10. If X10 is positive, then I want the result to be AS10. Can someone please help me?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated SUM IF formula | Excel Worksheet Functions | |||
Please Help with complicated SUM formula | Excel Worksheet Functions | |||
Complicated formula | Excel Discussion (Misc queries) | |||
Complicated IF Formula | Excel Worksheet Functions | |||
Complicated Formula | Excel Discussion (Misc queries) |