excel formulas

elynoy

Board Regular
Joined
Oct 29, 2018
Messages
124
Hello. I'd like to know if it possible to multiply a cell value converted to [h] with euro formated cell.

For exemple I have a cell with 88 formated as [h] and I want to multiply it by normal value "5.1" and retrieve the value in "euro" format.


exemple 88*5.1=448.8
but if I format the result as [h] or standard or any other value the result will not be the 448.8.

I hope I explained myself good enought.
Thanks in advance
eLy
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello,

You should try

Code:
=(88/24)*5.1

Hope this will help
 

elynoy

Board Regular
Joined
Oct 29, 2018
Messages
124
Beent trying to format in numerous ways.. so simple as add another *24 in it gosh I feel dumb.

Thank you

Best regards,
eLy
 

Watch MrExcel Video

Forum statistics

Threads
1,108,624
Messages
5,523,965
Members
409,547
Latest member
AW2020

This Week's Hot Topics

Top