在EXCEL中可以循环12次的公式写法

来源:百度知道 编辑:UC知道 时间:2024/06/20 04:06:16
如题所示当A1等于1的时候B1显示“***”当A1等于2的时候B1显示“****”.......当A1等于12的时候B1显示“*****”
大家不知看懂了没有就是让一个公视可以循环12次.不知道有没有高手可以解答我的这个难题?

你是想让IF嵌套12层,不是循环吧?如果是的话可以用定义名称的方式实现。

1254

A1=3到11之间的数时,是几个"*"呢?4个还是5个?

With the general improvement of the quality of life, the sea and land are not the only ways for people's travel, tourism , as the aviation industry has the advantage of time and gradually,it become the mainstream trend in transportation. In order to meet the needs of modern society the concept of a high time for a strong, ticket booking management system for the ticket booking office has brought great convenience. The purpose of this paper is to study the management of ticket booking system software development and application of ways, mainly because the management of today's cumbersome ticket reservations to the concept of time has a strong staff of the airline has brought a lot of inconvenience and the lack of a complete airline Booking of ticket management software, for Record of the booking, flight information, such as passenger information to facilitate the management, so