| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formatting
I have a value in cell A, i would like to display this value in cell B if it
is less than or equal to 667. If the value in cell A is greater than 667 i would like the value up to 667 displayed in cell B and the remaining value displayed in cell C. e.g. cell A = 141 cell B = 141 or cell A = 788 Cell B = 667 Cell C = 121 Can anyone help |
|
#2
|
|||
|
|||
|
Try this:
In cell B use this formula: =IF(A1<=667,A1,667) In cell C use this formula: =IF(A1667,A1-B1,0) "Hardy03" wrote: I have a value in cell A, i would like to display this value in cell B if it is less than or equal to 667. If the value in cell A is greater than 667 i would like the value up to 667 displayed in cell B and the remaining value displayed in cell C. e.g. cell A = 141 cell B = 141 or cell A = 788 Cell B = 667 Cell C = 121 Can anyone help |
|
#3
|
|||
|
|||
|
Thankyou that was really helpful
"David Hepner" wrote: Try this: In cell B use this formula: =IF(A1<=667,A1,667) In cell C use this formula: =IF(A1667,A1-B1,0) "Hardy03" wrote: I have a value in cell A, i would like to display this value in cell B if it is less than or equal to 667. If the value in cell A is greater than 667 i would like the value up to 667 displayed in cell B and the remaining value displayed in cell C. e.g. cell A = 141 cell B = 141 or cell A = 788 Cell B = 667 Cell C = 121 Can anyone help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| Formatting dates in the future | Excel Worksheet Functions | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
