Page 1 of 1

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

Posted: Wed Nov 15, 2017 9:52 am
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")

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

Posted: Wed Nov 15, 2017 10:10 am
by Christopher
=IF(H13="yes", 25.0, 0.0)

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

Posted: Wed Nov 15, 2017 12:29 pm
by simonmlewis
Ahh yes that’s it.