| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula with negative amount
I have a formula that currently reads like this
=IF(C45C47,C45,C47) I want to now be able to have it include the fact that either one of the cells could be a negative amount and pull that number. Would that be possible? Thank you in advance for any help. Roxy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with negative amount
Maybe...
=if(min(c45,c47)<0,min(c45,c47),max(c45,c47)) Roxy wrote: I have a formula that currently reads like this =IF(C45C47,C45,C47) I want to now be able to have it include the fact that either one of the cells could be a negative amount and pull that number. Would that be possible? Thank you in advance for any help. Roxy -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with negative amount
This works thank you!
~Roxy "Dave Peterson" wrote: Maybe... =if(min(c45,c47)<0,min(c45,c47),max(c45,c47)) Roxy wrote: I have a formula that currently reads like this =IF(C45C47,C45,C47) I want to now be able to have it include the fact that either one of the cells could be a negative amount and pull that number. Would that be possible? Thank you in advance for any help. Roxy -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with negative amount
Maybe this
=IF(OR(C45<0,C47<0),MIN(C45,C47),MAX(C45,C47)) Mike "Roxy" wrote: I have a formula that currently reads like this =IF(C45C47,C45,C47) I want to now be able to have it include the fact that either one of the cells could be a negative amount and pull that number. Would that be possible? Thank you in advance for any help. Roxy |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with negative amount
This one works too, thank you!
~Roxy "Mike H" wrote: Maybe this =IF(OR(C45<0,C47<0),MIN(C45,C47),MAX(C45,C47)) Mike "Roxy" wrote: I have a formula that currently reads like this =IF(C45C47,C45,C47) I want to now be able to have it include the fact that either one of the cells could be a negative amount and pull that number. Would that be possible? Thank you in advance for any help. Roxy |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with negative amount
Please give an example of the values you have and wish to see.
Vaya con Dios, Chuck, CABGx3 "Roxy" wrote: I have a formula that currently reads like this =IF(C45C47,C45,C47) I want to now be able to have it include the fact that either one of the cells could be a negative amount and pull that number. Would that be possible? Thank you in advance for any help. Roxy |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with negative amount
=IF(C45<0,C45,IF(C47<0,C47,IF(C45C47,C45,C47)))
-- Greetings from New Zealand "Roxy" wrote in message ... I have a formula that currently reads like this =IF(C45C47,C45,C47) I want to now be able to have it include the fact that either one of the cells could be a negative amount and pull that number. Would that be possible? Thank you in advance for any help. Roxy |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with negative amount
=IF(C45<0,C45,IF(C47<0,C47,MAX(C45,C47)))
-- David Biddulph "Roxy" wrote in message ... I have a formula that currently reads like this =IF(C45C47,C45,C47) I want to now be able to have it include the fact that either one of the cells could be a negative amount and pull that number. Would that be possible? Thank you in advance for any help. Roxy |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with negative amount
These are all good, but now I have another problem. IF C47 is greater then
C45 then it still only is pulling the amt from C45??? Any ideas? Thanks everyone!! Roxy "David Biddulph" wrote: =IF(C45<0,C45,IF(C47<0,C47,MAX(C45,C47))) -- David Biddulph "Roxy" wrote in message ... I have a formula that currently reads like this =IF(C45C47,C45,C47) I want to now be able to have it include the fact that either one of the cells could be a negative amount and pull that number. Would that be possible? Thank you in advance for any help. Roxy |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with negative amount
Roxy,
A quick scan though all the solutions shows that everyones formula returns the max of C45 & C47 if they are both positive and the minimum of thos cells iif either or both are negative so Im confused. Please provide what answer you expect to the options C45 C47 1 2= 2 1= -1 1= 1 -1= -1 -1= -1 -2= -2 -1= Mike "Roxy" wrote: These are all good, but now I have another problem. IF C47 is greater then C45 then it still only is pulling the amt from C45??? Any ideas? Thanks everyone!! Roxy "David Biddulph" wrote: =IF(C45<0,C45,IF(C47<0,C47,MAX(C45,C47))) -- David Biddulph "Roxy" wrote in message ... I have a formula that currently reads like this =IF(C45C47,C45,C47) I want to now be able to have it include the fact that either one of the cells could be a negative amount and pull that number. Would that be possible? Thank you in advance for any help. Roxy |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with negative amount
I was just told I am good to go with the way you have shown me. No need to
worry about any thing else. So thank you so very much. Sorry for any extra confusion. :) ~Roxy "Mike H" wrote: Roxy, A quick scan though all the solutions shows that everyones formula returns the max of C45 & C47 if they are both positive and the minimum of thos cells iif either or both are negative so Im confused. Please provide what answer you expect to the options C45 C47 1 2= 2 1= -1 1= 1 -1= -1 -1= -1 -2= -2 -1= Mike "Roxy" wrote: These are all good, but now I have another problem. IF C47 is greater then C45 then it still only is pulling the amt from C45??? Any ideas? Thanks everyone!! Roxy "David Biddulph" wrote: =IF(C45<0,C45,IF(C47<0,C47,MAX(C45,C47))) -- David Biddulph "Roxy" wrote in message ... I have a formula that currently reads like this =IF(C45C47,C45,C47) I want to now be able to have it include the fact that either one of the cells could be a negative amount and pull that number. Would that be possible? Thank you in advance for any help. Roxy |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with negative amount
"Roxy" wrote:
These are all good, but now I have another problem. IF C47 is greater then C45 then it still only is pulling the amt from C45??? Any ideas? Based on the fact that you were basically pleased with Dave's solution (and others that were similar) and on the fact that your original formula did not do what you want, I presume that if the sign of both values is the same, you want the larger __magnitude__. For example, -45 is larger than -40 in magnitude, even though -45 is less than -40; and 45 is larger than 40 in magnitude). What is unclear is: which do you want if one cell has -45 and the other has 40? If you want -45 in that case, then you always want the larger in magnitude, regardless of sign. One solution: =if(abs(C45) abs(C47), C45, C47) If you want 40 in that case, then you only want the smaller negative number (larger in magnitude) when both numbers are negative. One solution: =if(max(C45,C47)<0, min(C45,C47), max(C45,C47)) Try the appropriate solution with the following combinations: -45 40 -40 45 -45 -40 45 40 If you do not like all of the results, please post back with __all__ of the expected results, not just the ones you don't like. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display negative $ amount?? | Excel Discussion (Misc queries) | |||
| how do i reflect a negative amount in brackets in excel? | Excel Discussion (Misc queries) | |||
| ENTER NEGATIVE AMOUNT | Excel Discussion (Misc queries) | |||
| Change negative amount to positive. | New Users to Excel | |||
| How do I enter a negative dollar amount? | Excel Discussion (Misc queries) | |||
Hybrid Mode
