Could someone please explain this IF formula / statement?

[Reef]

Hi all,

I have a spreadsheet left behind by an old staff member from years ago.
Could someone please help me understand the logic behind it?

=IF(C8="?",(C4*0.95),(C4*(C8+C6)/100))

I'm reading it as...

IF cell C8 = any number, even 0, THEN the cell=95%of C4,
ELSE (if the cell doesn't =0 or any other number) the cell =C8+C6% of C4

Am I understanding that corretly?

If so, what value of C8 will make the IF statement False? (ie cell=C8+C6% of C4

Please help gang... I have to deal with this in a meeting tomorrow.

 

[ken2step]

Re: Could someone please explain this IF formula / statement

This part "?" is saying if a question mark is in that cell then excute the first argument, if not then execute the 2nd argument.

 

[Reef]

Re: Could someone please explain this IF formula / statement

Ken,

Are you serious.

This guy has programmed a reference to a question mark.
So the function will always go to the ELSE statement of cell =C8+C6% of C4?

Would the statement opperate correctly if it were...

=IF(C8=?,(C4*0.95),(C4*(C8+C6)/100))

 

[ken2step]

Re: Could someone please explain this IF formula / statement

=IF(N(C8),(C4*0.95),(C4*(C8+C6)/100))

 

[Reef]

Re: Could someone please explain this IF formula / statement

Thanks Ken.

i must say, I've seen the If functions before but the "N" statement is completely new to me.

Is there a name for this type of statement?
I'd like to do a bit of reading up when I get a chance.

Thanks for taking to time to help too.

It's very very much appreciated

 

[ken2step]

Re: Could someone please explain this IF formula / statement

Go to Excel help files and type in Functions. They are listed there. Explains more then you'll want to know! LOL

 

[Reef]

Re: Could someone please explain this IF formula / statement

Thanks Ken.

I've had a good read.
Now for the meeting this afternoon where I break the news to the mangement team!

 

[Martin Perera]

Hi

I am new this site,

Go to Excel help files and type in Functions.

but where are the help files located (Url)

I had a look but must have missed them>>>

cheers martin

 

[ken2step]

Re: Could someone please explain this IF formula / statement

With Excle open....just hit the F1 key or go to main menu to the far right and click on Help.

 

[Martin Perera]

Re: Could someone please explain this IF formula / statement

Ahhh

misread the thread thought it was a 'Help' page on this site.....


Duh