Formula problem

[David]

I would be be very grateful if somone could help me with the following
formula problem I have.
H4=IF(F4<>"",PI()*E4/(6.5*F4),PI()*E4/G4)
Q1) What does this part of the formula do F4<>""
Q2) I only want the formula to calculate if there is a value in either F4
or G4 not both.

 

[Mike H]

David,

Did you actually get the formula working from you other post?

1. <> means different than or does not equal so in the case of your formula
it's looking if F4 is an empty string (Not necessarily an empty cell)

=IF(AND(F4>0,G4>0),"",IF(F4<>"",PI()*E4/(6.5*F4),PI()*E4/G4))
The above wont calculate if both F4 & G4 are populated

Mike

 

[Pranav Vaidya]

Q1) What does this part of the formula do F4<>""
The formula is checking whethere cell F4 is blank or not. '<>' means not
eaqual to. In short if F4 is not blank, the formula will execute first part
in IF() otherwise the later part in IF().

Q2) I only want the formula to calculate if there is a value in either F4 or
G4 not both.
Replace F4<>"" with OR(F4<>"",G4<>"")

This will ensure that there should be value in one of the cells.

 

[David Biddulph]

But OR(F4<>"",G4<>"") does not exclude cases where there are values for both
F4 and G4, which is what the OP asked for.
Perhaps the condition should be IF(COUNT(F4,G4)=1,... ?