| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if formula return
hello, i need help with an IF formula. I want the 'true' return to be value
of one cell minus another but not greater than the value of another cell. How would I phrase in my formula after my argument? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula return
=IF(A1-A2C1,A1-A2,C1)
should work "Theresa" wrote: hello, i need help with an IF formula. I want the 'true' return to be value of one cell minus another but not greater than the value of another cell. How would I phrase in my formula after my argument? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula return
Min will do what you want, as in:
=min(a2-a1,a3) Regards, Fred. "Theresa" wrote in message ... hello, i need help with an IF formula. I want the 'true' return to be value of one cell minus another but not greater than the value of another cell. How would I phrase in my formula after my argument? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula return
=IF(condition,MIN(A1-B1,C1),value_if_false)
-- David Biddulph "Theresa" wrote in message ... hello, i need help with an IF formula. I want the 'true' return to be value of one cell minus another but not greater than the value of another cell. How would I phrase in my formula after my argument? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula return
Sorry, I might have mis-read your request;
Fred may not have,,,,,, "JMay" wrote: =IF(A1-A2C1,A1-A2,C1) should work "Theresa" wrote: hello, i need help with an IF formula. I want the 'true' return to be value of one cell minus another but not greater than the value of another cell. How would I phrase in my formula after my argument? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Last Value in a Row formula | Excel Worksheet Functions | |||
| No return for formula | Excel Worksheet Functions | |||
| Formula to Return Last Non-Zero Value in Row | Excel Worksheet Functions | |||
| I Need a Formula to return a zero value | Excel Worksheet Functions | |||
| I need help with way to return 0 or N/A to a formula | New Users to Excel | |||
Linear Mode
