IF function will not work? Can you see why??

  • Thread starter Thread starter Amilio
  • Start date Start date
A

Amilio

Greetings!

What I have is a spreadsheet that I use as a calculator
for roofing materials and I want it to make the
calculation if a "y" is entered in cell D29 (meaning yes
we need gravel) but it will not.
I've entered this formula:

IF(D29=y,SUM(E27/4),No Gravel Needed)

and it doesn't work!! I don't even get an error message.
It just shows up in the cell as if the computer doesn't
recognize it as a formuala but instead thinks of it as
text. Does anybody know why that is? I've tried changing
D29 to a 1 because I thought the formula didn't recognize
an alpha but that doesn't work either.
 
Hi Amilio!

Try:

IF(D29="y",SUM(E27/4),No Gravel Needed)

You need the "" because othwise Excel is looking for the named
variable y as opposed to the letter y.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Doh!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top