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 have cell H4=((PI()*(E4))/(6.5*F4)) What i would like to do is have a formula which is calculated when there is either a value in F4 or G4. However I don't want G4 multiplied by 6.5. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula problem
this ..?
=IF(F4<"",PI()*E4/(6.5*F4),PI()*E4/G4) "David" wrote: I would be very grateful if someone could help me with the following formula problem i have cell H4=((PI()*(E4))/(6.5*F4)) What i would like to do is have a formula which is calculated when there is either a value in F4 or G4. However I don't want G4 multiplied by 6.5. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem | Excel Worksheet Functions | |||
IF Formula Problem | Excel Discussion (Misc queries) | |||
formula problem | Excel Worksheet Functions | |||
Problem with formula | Excel Worksheet Functions | |||
Need a formula for this problem | Excel Worksheet Functions |