Formula Problem
 

I would be very grateful if someone could help me with the following formula
problem.

I would like cell H to calculate in a certain way when there is a value in
cell G and also cell H to calculate in a certain way when there is a value in
cell F.
when there is a value in F i would like it to calculate the following
formula:
PI()*E4/(6.5*F4)
when there is a value in cell G i would like it to do the following formula:
PI()*E4/G4
I would like it set up so that it will not calculate if there is a value in
F and G.

Formula Problem
 

David,

Why don't you look at your previous post(s)

Mike

"David" wrote:

I would be very grateful if someone could help me with the following formula
problem.

I would like cell H to calculate in a certain way when there is a value in
cell G and also cell H to calculate in a certain way when there is a value in
cell F.
when there is a value in F i would like it to calculate the following
formula:
PI()*E4/(6.5*F4)
when there is a value in cell G i would like it to do the following formula:
PI()*E4/G4
I would like it set up so that it will not calculate if there is a value in
F and G.

Formula Problem
 

Hi David,

Put this formula in H4 cell... enjoy!!

=IF(AND(F4<"",G4<""),"",IF(AND(F4<"",G4=""),PI( )*E4/(6.5*F4),IF(AND(F4="",G4<""),PI()*E4/G4,"")))


Regards,
Sameer Nagi

"David" wrote:

I would be very grateful if someone could help me with the following formula
problem.

I would like cell H to calculate in a certain way when there is a value in
cell G and also cell H to calculate in a certain way when there is a value in
cell F.
when there is a value in F i would like it to calculate the following
formula:
PI()*E4/(6.5*F4)
when there is a value in cell G i would like it to do the following formula:
PI()*E4/G4
I would like it set up so that it will not calculate if there is a value in
F and G.