CODEWITHSUNDEEP
google-sheetsspreadsheet
MJCael
MJCael

Reputation: 11

Currency Conditional formatting in Google Sheets

I am looking to automatically format my cells in a way that when the amount of a cell is already at more than 50,000 it automatically converts to IDR currency but if it's below that amount, it would be on $ currency. Please help

Upvotes: 1

Views: 627

Answers (1)

marikamitsos
marikamitsos

Reputation: 10573

Please try the following formula

=INDEX(IF(LEN(B2:B),
     IF(B2:B>=50000,TEXT(B2:B*GOOGLEFINANCE("Currency:USDIDR"),"Rp0.00"),TEXT(B2:B,"$0.00")),""))

enter image description here

Functions used:

Upvotes: 2

Related Questions