Hi, I need to write a what if statement for this:
If $1.00 to $34999.99 = CM
If $35,000.00 to $100,000.00 = AA
If over $100,000 = FCCNN
Please help
Hi, I need to write a what if statement for this:
If $1.00 to $34999.99 = CM
If $35,000.00 to $100,000.00 = AA
If over $100,000 = FCCNN
Please help
Try
=IFERROR(LOOKUP(A1,{1,35000,100001},{"CM","AA","FCCN"}),"N/A")
Try:
=IF(A1>100000,"FCCNN",IF(A1>34999.99,"AA","CM"))
If I've helped U pls click on d *Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks