Help with formula
 

F column works fine, H column will only work if there is something in A
column otherwise H column gives me the #VALUE! error

F column has:
=If(OR(B1125<"\\\\\\CC\\\\\\",A1125=""),"",ROUNDU P(E1125,0)-E1125)
H column has: =(IF(OR(E1125,G11250),H1124-E1125-F1125+G1125,""))

Thanks ih advance!

Help with formula
 

Put a check in the formula in col H to see if anything is in it. I am not
sure what your formula is column H is trying to do in the OR statement. What
is E1125 suppose to be checking.



"Richard" wrote:

F column works fine, H column will only work if there is something in A
column otherwise H column gives me the #VALUE! error

F column has:
=If(OR(B1125<"\\\\\\CC\\\\\\",A1125=""),"",ROUNDU P(E1125,0)-E1125)
H column has: =(IF(OR(E1125,G11250),H1124-E1125-F1125+G1125,""))

Thanks ih advance!

Help with formula
 

Just used for when I paste down several hundred cells ahead. What do you mean
by putting a check?

"WLMPilot" wrote:

Put a check in the formula in col H to see if anything is in it. I am not
sure what your formula is column H is trying to do in the OR statement. What
is E1125 suppose to be checking.



"Richard" wrote:

F column works fine, H column will only work if there is something in A
column otherwise H column gives me the #VALUE! error

F column has:
=If(OR(B1125<"\\\\\\CC\\\\\\",A1125=""),"",ROUNDU P(E1125,0)-E1125)
H column has: =(IF(OR(E1125,G11250),H1124-E1125-F1125+G1125,""))

Thanks ih advance!

Help with formula
 

First of all, I am not sure what E1125 is suppose to be checking against, ie
<, =, , <, some value in the OR statement.

You mention H col only works when something is in A col, but I do not see a
reference to A col in your formula.

A check is done by an IF statement. Lets say A1 is null and you have a
formula that references A1. First check to see if A1 has a valid value prior
to executing the formula. Let's say I want to calculate a price (in A1)
times 1.05 and the formula is in B1.

=IF(A1="","",A1*1.05)

In your case, you check for a value first, then insert your formula inplace
of the (A1*1.05).

Les

"Richard" wrote:

Just used for when I paste down several hundred cells ahead. What do you mean
by putting a check?

"WLMPilot" wrote:

Put a check in the formula in col H to see if anything is in it. I am not
sure what your formula is column H is trying to do in the OR statement. What
is E1125 suppose to be checking.



"Richard" wrote:

F column works fine, H column will only work if there is something in A
column otherwise H column gives me the #VALUE! error

F column has:
=If(OR(B1125<"\\\\\\CC\\\\\\",A1125=""),"",ROUNDU P(E1125,0)-E1125)
H column has: =(IF(OR(E1125,G11250),H1124-E1125-F1125+G1125,""))

Thanks ih advance!