Posted to microsoft.public.excel.misc

David

external usenet poster

Posts: 1,560

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Problem need help	David	Excel Worksheet Functions	3	May 25th 07 02:22 AM
Formula problem	Dave	Excel Discussion (Misc queries)	3	January 30th 07 10:58 PM
What is the problem with this formula?	Teethless mama	Excel Worksheet Functions	1	January 21st 07 06:18 PM
problem with a formula	WYN	Excel Discussion (Misc queries)	1	September 24th 05 04:44 AM
Formula problem	Giff	Excel Discussion (Misc queries)	5	March 31st 05 11:23 PM

All times are GMT +1. The time now is 12:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us