Carine Hough
New Member
Joined: May 26, 2016
Follow
RE: If one cell have any text than answer as 2000
Hi Waqas No problem, I have wrapped the formula in another IF function to deal with this condition too. =IF(A2="", "", IF(A2="2 Stops", 1000, IF...
6 years ago
RE: If one cell have any text than answer as 2000
Hello Waqas Munir I have used the following formula to solve your problem: =IF(A2="2 Stops", 1000, IF(C2<>"", 6000, IF(B2<>"", 4000,...
6 years ago