Formula Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top