| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
# Value formula
I have a formula thats keeps giving me this return: in cell
J47=if(I47<25,H47<if(I47=25,H47+I47)) Is ther a way to prevent this? |
|
#2
|
|||
|
|||
|
I bet you typed in the wrong formula in the post.
But check each of those cells to see if they are all numeric. (if you have text in H47, then H47+I47 would cause that error.) Colin2u wrote: I have a formula thats keeps giving me this return: in cell J47=if(I47<25,H47<if(I47=25,H47+I47)) Is ther a way to prevent this? -- Dave Peterson |
|
#3
|
|||
|
|||
|
"?B?Q29saW4ydQ==?=" wrote in
: I have a formula thats keeps giving me this return: in cell J47=if(I47<25,H47<if(I47=25,H47+I47)) Is ther a way to prevent this? Is it a typo? =if(I47<25,H47,if(I47=25,H47+I47)) This does the same: =if(I47<25,H47,H47+I47) Looks better that way. Or do I miss something? -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
