IF Formula?

S

shane

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
Click to expand...

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

cheers
 
B

Bob Phillips

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

shane

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

cheers
 
F

fede1845

B9 = people
B8 = days and
0.5 = kilos
Click to expand...

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

Hi,

If I understood correctly, I would use the following:

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

Hope it works
 
S

shane

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??
 
S

shane

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
 
R

Roger Govier

Hi Shane

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