# Could someone please explain this IF formula / statement?

#### Reef

##### New Member
Hi all,

I have a spreadsheet left behind by an old staff member from years ago.

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

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

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
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.

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))

Re: Could someone please explain this IF formula / statement

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

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

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

Re: Could someone please explain this IF formula / statement

Thanks Ken.

Now for the meeting this afternoon where I break the news to the mangement team!

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

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.

Re: Could someone please explain this IF formula / statement

Ahhh

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

Duh

Replies
1
Views
361
Replies
4
Views
1K
Replies
1
Views
508
Replies
6
Views
530
Replies
0
Views
442

1,221,212
Messages
6,158,562
Members
451,498
Latest member
tyshanklin1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back