I am trying to use the following formula and I am getting the #VALUE! error. Any thoughts:
=IF(J29=0,"",1&":"&(ROUNDDOWN(AVERAGE(J12:J26=0,"",J12:J26),0)))
Thanks
I am trying to use the following formula and I am getting the #VALUE! error. Any thoughts:
=IF(J29=0,"",1&":"&(ROUNDDOWN(AVERAGE(J12:J26=0,"",J12:J26),0)))
Thanks
What is the data you are using it on?
If someone helped give them rep using the star button.
If you have received a satisfactory solution please mark the thread solved. If not Fotis will come for you at night :P
It is all numeric. The cells the formula is referencing all are either empty or contain decimal numbers such as 2.00, 5.00, etc. Also, if it is any help the cells the formula is reading contains the following formula:
=IF(G19=0,"",ROUNDDOWN(H19/G19,0))
=IF(J29=0,"",1&":"&(ROUNDDOWN(AVERAGE(J12:J26=0,0,J12:J26),0)))
Your formula, works if you remove the ""
If it helps I was using the following formula first which worked, but I needed it to rounddown:
=IF(J29=0,"",1&":"&AVERAGE(IF(J12:J26=0,"",J12:J26)))
Rounddown() doesn't work on text, by using "" you are trying to pass rounddown() text.
Are you trying to come up witha Ratio?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks