| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to set up a conditional formula
I would like to set up a conditional formula but am not sure how to do it. If
A1-B1 0, then put the answer in cell D10, but if A1-B1 is = 0 or < 0 then put the answer in cell D12. Any help would be appreciated. MEB |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to set up a conditional formula
A formula can only return a value to one cell. So in D10 enter
=IF(A1-B10,A1-B1,"") and in D12 enter =IF(A1-B1<=0,A1-B1,"") Hope this helps Rowan "MEB" wrote: I would like to set up a conditional formula but am not sure how to do it. If A1-B1 0, then put the answer in cell D10, but if A1-B1 is = 0 or < 0 then put the answer in cell D12. Any help would be appreciated. MEB |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to set up a conditional formula
It worked Thank you.MEB
"Rowan Drummond" wrote: A formula can only return a value to one cell. So in D10 enter =IF(A1-B10,A1-B1,"") and in D12 enter =IF(A1-B1<=0,A1-B1,"") Hope this helps Rowan "MEB" wrote: I would like to set up a conditional formula but am not sure how to do it. If A1-B1 0, then put the answer in cell D10, but if A1-B1 is = 0 or < 0 then put the answer in cell D12. Any help would be appreciated. MEB |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to set up a conditional formula
You're welcome.
"MEB" wrote: It worked Thank you.MEB "Rowan Drummond" wrote: A formula can only return a value to one cell. So in D10 enter =IF(A1-B10,A1-B1,"") and in D12 enter =IF(A1-B1<=0,A1-B1,"") Hope this helps Rowan "MEB" wrote: I would like to set up a conditional formula but am not sure how to do it. If A1-B1 0, then put the answer in cell D10, but if A1-B1 is = 0 or < 0 then put the answer in cell D12. Any help would be appreciated. MEB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Sum Formula? | Excel Discussion (Misc queries) | |||
| need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. | Excel Worksheet Functions | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Conditional Formatting formula not acceptable? | Excel Discussion (Misc queries) | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Hybrid Mode
