Formula problem
 

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.

Formula problem
 

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(F40,G40),"",IF(F4<"",PI()*E4/(6.5*F4),PI()*E4/G4))
The above wont calculate if both F4 & G4 are populated

Mike

"David" wrote:

I would be be very grateful if somone could help me with the following
formula problem I have.
=IF(F4<"",PI()*E4/(6.5*F4),PI()*E4/G4)
=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.

Formula problem
 

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.


--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"David" wrote:

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.

Formula problem
 

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,... ?
--
David Biddulph

"Pranav Vaidya" wrote in message
...
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" wrote:

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.