| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
complex IF formula returns #VALUE!
=IF(AND(SUMIF(Form!I1:I100,"C",Form!N1:N100)-form2!G14<1.1,SUMIF(Form!I1:I100,"C",Form!N1:N100)-form2!G14-1.1),"ok","check")
I have a formula like this. I doubt check every cell and these related two forms. They have valid data there. Could someone give me a hint where I might find the problem? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "IF" formula returns zero or other incorrect number | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| How to insert a complex formula in a cell with VBA | Excel Worksheet Functions | |||
| complex formula | Excel Worksheet Functions | |||
Threaded Mode
