IF Formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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)
 
Thanks bob, any ideas on how to get the answer expressed with a kg sign after
the numbers??

cheers
 
shane said:
i was kindly helped with the forumula

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

to the query


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

=IF(A1'"YES", B9*B8*0.5,0)
... and give answers in kg???
Click to expand...

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. :-(
 
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
 
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"))
 
Back
Top