• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

MID AND IF Function

Hi,

Ive written an IF Statement

=IF(E2="Yes","=MID(C2,4,10)","")

Its just dropping the text in i.e. =MID(C2,4,10)

Can someone amend?

Thanks
Seamus
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
SiddharthRoutCommented:
Is this what you want?

=IF(E2="Yes",MID(C2,4,10),"")

Sid
0
 
Seamus2626Author Commented:
Perfect!
Thanks
Seamus
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now