Posted to microsoft.public.excel.misc

Jillian

external usenet poster

Posts: 1

IF Statements

Hi, I was hoping someone would be able to assist me. I am looking for a
formula where if I6<G6 then 0 BUT if I6G6 then I6-G6. Basically if I6 is
greater than G6 the cell needs to populate the difference. I have tried
everything and I get is #NAME? or #VALUE errors.
Thanks!

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
IF Statements	Ben Joseph[_2_]	Excel Worksheet Functions	2	April 15th 09 06:14 PM
IF Statements	Rebecca	Excel Worksheet Functions	1	December 5th 06 05:09 PM
If, Then Statements	RS	Excel Worksheet Functions	2	December 1st 06 01:49 AM
IF Statements (Mutliple Statements)	Deezel	Excel Worksheet Functions	3	October 19th 06 06:13 AM
How to Sum with two if statements	jliz2803	Excel Worksheet Functions	1	February 23rd 06 07:22 PM

All times are GMT +1. The time now is 08:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us