| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to use one or the other cell amount
I want a cell to show the amount of one of two other cells. Of the two other
cells, only one will have an amount at any time. for cell D10, if D5 has an amount, use that amount in D10. If D5 does not have an amount, use the amount in D7 for D10. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to use one or the other cell amount
One way
In D10: =IF(COUNT(D5,D7)=0,"",SUM(D5,D7)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Spiritdancer" wrote: I want a cell to show the amount of one of two other cells. Of the two other cells, only one will have an amount at any time. for cell D10, if D5 has an amount, use that amount in D10. If D5 does not have an amount, use the amount in D7 for D10. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to use one or the other cell amount
Put this formula in D10:
=IF(OR(D5="",D5=0),D10,D5) Hope this helps. Pete On Nov 16, 9:09 pm, Spiritdancer wrote: I want a cell to show the amount of one of two other cells. Of the two other cells, only one will have an amount at any time. for cell D10, if D5 has an amount, use that amount in D10. If D5 does not have an amount, use the amount in D7 for D10. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to use one or the other cell amount
=IF(D5,D5,D7)
"Spiritdancer" wrote: I want a cell to show the amount of one of two other cells. Of the two other cells, only one will have an amount at any time. for cell D10, if D5 has an amount, use that amount in D10. If D5 does not have an amount, use the amount in D7 for D10. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to use one or the other cell amount
Sorry, this should be:
=IF(OR(D5="",D5=0),D7,D5) Pete On Nov 16, 9:24 pm, Pete_UK wrote: Put this formula in D10: =IF(OR(D5="",D5=0),D10,D5) Hope this helps. Pete On Nov 16, 9:09 pm, Spiritdancer wrote: I want a cell to show the amount of one of two other cells. Of the two other cells, only one will have an amount at any time. for cell D10, if D5 has an amount, use that amount in D10. If D5 does not have an amount, use the amount in D7 for D10.- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have a delay in formula results when I change one cell amount | Excel Discussion (Misc queries) | |||
| sales tax total amount from one cell amount to another cell | Excel Discussion (Misc queries) | |||
| Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
| Round amount to nearest $10 after other formula calc. in same cell | Excel Worksheet Functions | |||
| How do I print formula figures and calculated amount in a cell? | Excel Discussion (Misc queries) | |||
Linear Mode
