Could someone please explain this IF formula / statement?

Reef

New Member
Joined
Jul 12, 2003
Messages
41
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? :rolleyes:

=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 :oops:

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

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

ken2step

Well-known Member
Joined
Jan 9, 2003
Messages
632
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

New Member
Joined
Jul 12, 2003
Messages
41
Re: Could someone please explain this IF formula / statement

Ken,

Are you serious. :eek:

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

Well-known Member
Joined
Jan 9, 2003
Messages
632
Re: Could someone please explain this IF formula / statement

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

Reef

New Member
Joined
Jul 12, 2003
Messages
41

ADVERTISEMENT

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

Well-known Member
Joined
Jan 9, 2003
Messages
632
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

New Member
Joined
Jul 12, 2003
Messages
41

ADVERTISEMENT

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! :rolleyes:
 

Martin Perera

Board Regular
Joined
Jan 17, 2005
Messages
147
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

Well-known Member
Joined
Jan 9, 2003
Messages
632
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

Board Regular
Joined
Jan 17, 2005
Messages
147
Re: Could someone please explain this IF formula / statement

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


Duh :confused:
 

Forum statistics

Threads
1,148,525
Messages
5,747,203
Members
424,068
Latest member
Salim khamis

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top