Forum Discussion
Adding a text behind the amount in a IF calculation
Hello, I would like some help to add GB (gigabyte) after some of the calculations I have done in a =IF function. For example, in column D5 I have a list with data usage in GB. Looks like 1 GB, 2 GB, ...
Riny_van_Eekelen Ty for your help. I have added the sheet. I am using Office365 so I guess the latest version of excel
Jonas44405 Thanks, but can you now please explain what need to be displayed and where? The formula in Q16 seems to be just sitting there as an example.
- Yes, it's an example so that I can try it before I add it. Q16 formula should be added to F5. What I want is to when change GB in D5, F5 should automatically reflect this. In the example, everything below 10GB and 10GB should be reflected as 10GB in F5. I also would like F5 to have GB after and not only 10 as I have in my example. Add text and numbers. For GB above 50GB I would like F5 to reflect Unlimited (text). Ty
Jonas44405 Added some extra information in column AG and used XLOOKUP in F5. Is that what you want?
- Yes exactly 🙂 thank you. And this could also be used in H5, J5, etc?