Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula problem | Excel Discussion (Misc queries) | |||
Formula problem | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Worksheet Functions | |||
Formula problem | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Discussion (Misc queries) |