Jun 07 2022 07:39 AM
I have a formula in cell B1: =IF(A1<500, 500) but if A1 is greater than 500, B1 shows FALSE and I need that cell to be blank in that case
View best response
Jun 07 2022 07:42 AM
@tlwarranties
=IF(A1<500,500,"")
You can try this formula.
Jun 07 2022 07:48 AM
Jun 07 2022 08:18 AM
You are welcome.
View solution in original post