Home |
Search |
Today's Posts |
#1
|
|||
|
|||
RE add cells together if value has a formula
I have in cell F26 formulas that produce numbers 0-24 when I add two cells
together providing that F26 =1 the two cells add together do not give the result according to the formula. eg: =IF(F26=0,K52,K52+J52) this formula only adds K52+J52 but does not give K52 on its own if F26=1 I think it is because F26 has a formula MID(C27,5,1) which gives the answer of 1 I have to use the MID funtion to extract a single number from 11400 all in one cell please help thaks bill gras |
#2
|
|||
|
|||
Hi!
MID(C27,5,1) I have to use the MID funtion to extract a single number from 11400 all in one cell MID is a TEXT function and returns TEXT even if the referenced cell is numeric. You can convert the TEXT number to a true numeric number like this: =--MID(C27,5,1) Based on the formula and the referenced cell value of 11400, the returned result will be 0. Biff "bill gras" wrote in message ... I have in cell F26 formulas that produce numbers 0-24 when I add two cells together providing that F26 =1 the two cells add together do not give the result according to the formula. eg: =IF(F26=0,K52,K52+J52) this formula only adds K52+J52 but does not give K52 on its own if F26=1 I think it is because F26 has a formula MID(C27,5,1) which gives the answer of 1 I have to use the MID funtion to extract a single number from 11400 all in one cell please help thaks bill gras |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
see the cells the formula relates to by double clicking the cell | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
Need a 1 Column multiplication formula for 2600 cells. How? | Excel Worksheet Functions | |||
How do i select different cells to be use in a formula. | Excel Discussion (Misc queries) |