Excel: How do I show £25 if Cell B5 = "yes"?

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
simonmlewis
DevNet Master
Posts: 4435
Joined: Wed Oct 08, 2008 3:39 pm
Location: United Kingdom
Contact:

Excel: How do I show £25 if Cell B5 = "yes"?

Post by simonmlewis »

I use to do a lot of Excel queries, but I am not extremely patchy with it.

I just want to say, if B5 is "yes", then make A4 = "£25". Else, I suppose, £0.00.

I thought it was something like this: =IF((H13=yes),"25")
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Excel: How do I show £25 if Cell B5 = "yes"?

Post by Christopher »

=IF(H13="yes", 25.0, 0.0)
(#10850)
simonmlewis
DevNet Master
Posts: 4435
Joined: Wed Oct 08, 2008 3:39 pm
Location: United Kingdom
Contact:

Re: Excel: How do I show £25 if Cell B5 = "yes"?

Post by simonmlewis »

Ahh yes that’s it.
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
Post Reply