• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

  • example.xlsx
    8.6 KB · Views: 3
U can use this one also in G7:
=IF((F7>=D7)*(F7<=E7),"Normal",IF(F7>E7,"Yes","Fail"))

hi @Juniad thanks for your help

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?
 
Back
Top