Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula structure
Need this formula in "F1" and "B1" contains text!
If B1<\\\\CC\\\\ "Then Do "", Else Roundup(E1,0)-E1, And If "A1" = "" Then Do "", Else Roundup(E1,0)-E1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula structure
I am not sure what you want but try
=if(and(B1<"\\\\CC\\\\",A1=""),"",Roundup(E1,0)-E1) unless what you want is for the center of a 1 0 character sequance in B1 to be CC then =if(and(mid(B1,5,2)<"CC",A1=""),"",Roundup(E1,0)-E1) "Richard" wrote: Need this formula in "F1" and "B1" contains text! If B1<\\\\CC\\\\ "Then Do "", Else Roundup(E1,0)-E1, And If "A1" = "" Then Do "", Else Roundup(E1,0)-E1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula structure
That fixed the problem in "F column" but it's giving me a #Value! error in
"H column" where I have more formulas connected to "F column" Here's whats in "H column" =(IF(OR(E1125,G11250),H1124-E1125-F1125+G1125,"")) "bj" wrote: I am not sure what you want but try =if(and(B1<"\\\\CC\\\\",A1=""),"",Roundup(E1,0)-E1) unless what you want is for the center of a 1 0 character sequance in B1 to be CC then =if(and(mid(B1,5,2)<"CC",A1=""),"",Roundup(E1,0)-E1) "Richard" wrote: Need this formula in "F1" and "B1" contains text! If B1<\\\\CC\\\\ "Then Do "", Else Roundup(E1,0)-E1, And If "A1" = "" Then Do "", Else Roundup(E1,0)-E1 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula structure
Your OR function is not properly constructed - do you mean this:
=IF(OR(E11250,G11250),H1124-E1125-F1125+G1125,"") ^^ Changes made indicated by the carets, and I've also removed a pair of redundant brackets. Hope this helps. Pete Richard wrote: That fixed the problem in "F column" but it's giving me a #Value! error in "H column" where I have more formulas connected to "F column" Here's whats in "H column" =(IF(OR(E1125,G11250),H1124-E1125-F1125+G1125,"")) "bj" wrote: I am not sure what you want but try =if(and(B1<"\\\\CC\\\\",A1=""),"",Roundup(E1,0)-E1) unless what you want is for the center of a 1 0 character sequance in B1 to be CC then =if(and(mid(B1,5,2)<"CC",A1=""),"",Roundup(E1,0)-E1) "Richard" wrote: Need this formula in "F1" and "B1" contains text! If B1<\\\\CC\\\\ "Then Do "", Else Roundup(E1,0)-E1, And If "A1" = "" Then Do "", Else Roundup(E1,0)-E1 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula structure
Sorry still not working! F column works fine, and H column works only when A
column has something in it otherwise It's giving me the #VALUE! Recap: F column =IF(OR(B1125<"\\\\\\CC\\\\\\",A1125=""),"",ROUNDU P(E1125,0)-E1125) H column =(IF(OR(E1125,G11250),H1124-E1125-F1125+G1125,"")) Thanks in advance for your help!! "Pete_UK" wrote: Your OR function is not properly constructed - do you mean this: =IF(OR(E11250,G11250),H1124-E1125-F1125+G1125,"") ^^ Changes made indicated by the carets, and I've also removed a pair of redundant brackets. Hope this helps. Pete Richard wrote: That fixed the problem in "F column" but it's giving me a #Value! error in "H column" where I have more formulas connected to "F column" Here's whats in "H column" =(IF(OR(E1125,G11250),H1124-E1125-F1125+G1125,"")) "bj" wrote: I am not sure what you want but try =if(and(B1<"\\\\CC\\\\",A1=""),"",Roundup(E1,0)-E1) unless what you want is for the center of a 1 0 character sequance in B1 to be CC then =if(and(mid(B1,5,2)<"CC",A1=""),"",Roundup(E1,0)-E1) "Richard" wrote: Need this formula in "F1" and "B1" contains text! If B1<\\\\CC\\\\ "Then Do "", Else Roundup(E1,0)-E1, And If "A1" = "" Then Do "", Else Roundup(E1,0)-E1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |