Background: I have a drop down box that allows you to check what type of fuel you're using for water heating.
If it's one, then it will calc the number (true) and label it accordingly, if the other (false) it will label it accordingly as well.
My problem is that once I added the labeling part to the formula, the numbers no longer round to the nearest whole number, which is what I need.
=IF(E3="LP",M3/(100000*I3),M3/(3413*I3))&IF(E3="LP"," Therms"," kWh")
E3 is my fuel (LP,ELEC)
I3 is % in decimal form.
M3 is any number (usually in the millions)
Please help.
Mahalo
You will be asked to put your code into code brackets. You can try this:
Code:=ROUND(IF(E3="LP",M3/(100000*I3),M3/(3413*I3)),0) &IF(E3="LP"," Therms"," kWh")
You don't necessarily need an array formula, but could simply insert the ROUND function into your existing formula.
=IF(E3="LP",ROUND(M3/(100000*I3),0),ROUND(M3/(3413*I3),0))&IF(E3="LP"," Therms"," kWh")
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks