Thread
:
Dividing the value of a cell if another cell equals a set value
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
vezerid
Posts: n/a
Dividing the value of a cell if another cell equals a set value
John,
if you want column D:D to remain blank for non EUR currencies, then use
this formula:
=IF(B2="EUR", A2*0.74, "")
HTH
Kostis Vezerides
Reply With Quote
Dividing the value of a cell if another cell equals a set value