i was kindly helped with the forumula

=IF(A1'"YES", B9*B8*0.5,"Not yes")

to the query

I have a questionnaire with drop down menu offering the user a YES or NO
response. I was hoping if the user selects YES that i could get excel to
trigger a simple equation like =B9*B8*0.5

probably simple when you know how.

many thanks

shane

but what if forgot to ask is how can I make "NO" equate to 0(zero) and give
answers in kg???

cheers

=IF(A1="YES", B9*B8*0.5,IF(A1="NO",0,"Not yes or no"))


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"shane" wrote in message
...
i was kindly helped with the forumula

=IF(A1'"YES", B9*B8*0.5,"Not yes")

to the query

I have a questionnaire with drop down menu offering the user a YES or NO
response. I was hoping if the user selects YES that i could get excel to
trigger a simple equation like =B9*B8*0.5

probably simple when you know how.

many thanks

shane

but what if forgot to ask is how can I make "NO" equate to 0(zero) and
give
answers in kg???

cheers

Thanks bob, any ideas on how to get the answer expressed with a kg sign after
the numbers??

cheers

"shane" wrote in message
...
i was kindly helped with the forumula

=IF(A1'"YES", B9*B8*0.5,"Not yes")

to the query

I have a questionnaire with drop down menu offering the user a YES or NO
response. I was hoping if the user selects YES that i could get excel to
trigger a simple equation like =B9*B8*0.5

probably simple when you know how.

many thanks

shane

but what if forgot to ask is how can I make "NO" equate to 0(zero) ...

=IF(A1'"YES", B9*B8*0.5,0)

... and give answers in kg???

Well you haven't told us whether your existing numbers are in ounces,
pounds, stones, tons, tonnes, or whatever.
If we have to guess the question, you may have to guess the answer. :-(
--
David Biddulph

B9 = people
B8 = days and
0.5 = kilos

FormatCellsNumberCustom #,##0.00 "kg"


Gord Dibben MS Excel MVP

On Thu, 18 Oct 2007 15:20:02 -0700, shane
wrote:

Thanks bob, any ideas on how to get the answer expressed with a kg sign after
the numbers??

cheers

On Oct 18, 3:40 pm, shane wrote:
B9 = people
B8 = days and
0.5 = kilos

++++++++++++++++++++++=

Hi,

If I understood correctly, I would use the following:

=IF(A1="YES",(B8*B9*0.5)&" Kilos",0&" Kilos")

Hope it works

Yes it worked, using as you suggested:
=IF(B45="YES",(B8*B9*0.5)&" Kilos",0&" Kilos")
But i tried to get IF NO = 0 kilos using:
=IF(B46="YES", B9*B8*0.5,IF(B46="NO",0,"Not yes or no"))&" Kilos",0&" Kilos")
Where have i gone wrong??

i just tried taking one of the brackets out

=IF(B46="YES", B9*B8*0.5,IF(B46="NO",0,"Not yes or no")&" Kilos",0&" Kilos")

but got an error message saying that i had too many arguments

Hi Shane

Try
=IF(B46="YES", B9*B8*0.5&" Kilos",IF(B46="NO",0&" Kilos","Not yes or no"))

--
Regards
Roger Govier



"shane" wrote in message
...
Yes it worked, using as you suggested:
=IF(B45="YES",(B8*B9*0.5)&" Kilos",0&" Kilos")
But i tried to get IF NO = 0 kilos using:
=IF(B46="YES", B9*B8*0.5,IF(B46="NO",0,"Not yes or no"))&" Kilos",0&"
Kilos")
Where have i gone wrong??