# Excel how to make formula to auto show word

#### Oscarr

##### Member
hi all

Excel how to make formula to auto show word?

example：my sell taget 288,888.00, but minimum 200,000.00, if greater than 288,888.00 show (Yes), between 288,888.00 to 200,000.00 show (normal), if less than 200,000.00 show (fail)...

Thanks

#### Attachments

• 8.6 KB Views: 2

#### bosco_yip

##### Excel Ninja
Try...........

In G7, enter formula :

=IF(F7="","",LOOKUP(F7,{0;200000;288889},{"fail";"normal";"Yes"}))

Regards

##### Member
U can use this one also in G7:
=IF((F7>=D7)*(F7<=E7),"Normal",IF(F7>E7,"Yes","Fail"))

#### Oscarr

##### Member
U can use this one also in G7:
=IF((F7>=D7)*(F7<=E7),"Normal",IF(F7>E7,"Yes","Fail"))

for this one =IF((F7>=D7)*(F7<=E7),"Normal"
if i want this between 200,000.00 to 288,887.90 only show (normal), because 288,888.00 already hit the target。

so how to make it?

#### Oscarr

##### Member
Try...........

View attachment 64866

In G7, enter formula :

=IF(F7="","",LOOKUP(F7,{0;200000;288889},{"fail";"normal";"Yes"}))

Regards
hi @bosco_yip
the formual can be like this?

less than 200,000.00 show (fail), accurate 200,000.00 show (maintain) between 200,000.01 to 288,887.99 show (rise) greater than 288,888.00 show (Yes)...

#### bosco_yip

##### Excel Ninja
Then, the formula changed to :

=IF(F7="","",LOOKUP(F7,{0;200000;200000.01;288888},{"fail";"maintain";"rise";"Yes"}))

Regards