Formula problem

D

David

I would be very grategul if someone could help me with a formula problem i
have.
Cell H4 has the following formula, H4
=IF(F4<>"",PI()*E4/(6.5*F4),PI()*E4/G4). However it does work. What should be
happening is that if there is a value in either F4 or G4 the formula will be
calculated. But nothing happens?!!
 
M

Mike H

David,

There's nothing wrong with the formula so:-

Is calculation set to manual? Tools|Options|Calculation check automatic
Is it actually a formula? Cut the formula out format cell as general and
paste it back.
Try Tools|Options|view un-check formulas.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula problem 3
Formula problem 1
#Div/0! 3
Conditional formatting for time 2
Returning last number(time) in a row of cells 4
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Formula Problem 2
When IF has limited iterations 10

Top