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")
Excel: How do I show £25 if Cell B5 = "yes"?
Moderator: General Moderators
-
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"?
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
All the best from the United Kingdom.
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
-
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"?
Ahh yes that’s it.
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
All the best from the United Kingdom.