Excel: How do I show £25 if Cell B5 = "yes"?
Posted: Wed Nov 15, 2017 9:52 am
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")
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")