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

Excel Change formula depends on a text field

Dear experts.

for example i've in Cell C20 3 different texts like  FUL, GUL, DUL and i want to change 2 Formulas in C21 and C22
depends on the TEXT in Cell C20

The first formula in C21 would be for "FUL"
="enable-mailbox -identity "&C3&" -Alias "&C3&"

and for "GUL"
="enable-mailbox -identity "&C3&" -Alias "&C3&" -database DBGUL1

and for "DUL"
="enable-mailbox -identity "&C3&" -Alias "&C3&" -database DBDUL1
0
Mandy_
Asked:
Mandy_
1 Solution
 
John EastonDirectorCommented:
If I understand correctly, depending on the value of C20 you want to display the relevant text.  You can do this using IF statements as detailed below:
=IF(C20="FUL","enable-mailbox -identity "&C3&" -Alias "&C3,IF(C20="GUL","enable-mailbox -identity "&C3&" -Alias "&C3&" -database DBGUL1",IF(C20="DUL","enable-mailbox -identity "&C3&" -Alias "&C3&" -database DBDUL1 ",FALSE)))

Open in new window


Hope this helps.
0
 
Mandy_Author Commented:
Yep, thats it. thank you
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